求助各位大神，这个提取公式该怎么写

lotusmjp · 发表于 2024-9-6 22:39

A1单元格内容是

[{"domain":".tiktok.com","expires":1757092125,"httpOnly":true,"name":"tt2fsd_token","path":"/","sameParty":false,"sameSite":"lax","secure":true,"session":false,"value":"eTlSpQ94-QU_MsZ1SHLgQ3JLq7Vq0VCAmR44"}
A2
[{"domain":".tiktok.com","expires":1757092125,"httpOnly":true,"name":"ttadf_csrf_token","path":"/","sameParty":false,"sameSite":"lax","secure":true,"session":false,"value":"eTlSpQ94-QU_MsZ1SHLgQ3JLq7Vq0VCAmR44"}
A3
[{"domain":".tiktok.com","expires":1757092125,"httpOnly":true,"name":"ttasdf_csrf_token","path":"/","sameParty":false,"sameSite":"lax","secure":true,"session":false,"value":"eTlSpQ94-QU_MsZ1SHLgQ3JLq7Vq0VCAmR44"}
现在想在
B1中提取

tt2fsd_token
也就是那么后面的这个东西

沈默00 · 发表于 2024-9-7 07:39

textafter
..........

leepoison · 发表于 2024-9-7 07:57

=TAKE(TAKE(TEXTSPLIT(E1,""""),,12),,-1)

无关岁月 · 发表于 2024-9-7 09:47

本帖最后由无关岁月于 2024-9-7 09:53 编辑

=REGEXEXTRACT(A1,"\w+(?="",""path)")

复制代码

无关岁月 · 发表于 2024-9-7 09:52

或者

=REGEXEXTRACT(A1,"\w+(?=...path)")

复制代码

pgp5866 · 发表于 2024-9-8 16:23

=REGEXEXTRACT(A4:A6,"name.+?\K\w+")

		自动登录	找回密码
密码			免费注册

[求助] 求助各位大神，这个提取公式该怎么写