这个提取文本怎么弄？

再回首-沉默 · 发表于 2024-10-29 16:42

hugeinfo · 发表于 2024-10-29 16:55

b2=REGEXP(A2,"\[\K\d+")

h2=REGEXP(G2,"\[\K\d+")
i2=IF(--TAKE(REGEXP(G2,"\K[\d+.]+"),,-1)>0.2,"0.2外","0.2内")

qwer401245 · 发表于 2024-10-29 16:48

小凡、、、 · 发表于 2024-10-29 16:58

=REGEXP(A2,"(?<=\[)\d+(?=\])")
=REGEXP(G2,"(?<=\[)\d+(?=\s)")
=TEXT(REGEXP(G2,"(?<=\s)\d+(\.\d+)?(?=\])"),"[>0.2]外;内")

无关岁月 · 发表于 2024-10-29 17:06

=LET(_f,LAMBDA(_f,REGEXP(G2,_f)),HSTACK(_f("\[\K\d+"),IF(REGEXP(_f("\s[\d.]+")-0.2,"-",1),"0.2内","0.2外")))

复制代码

gadxjyang · 发表于 2024-10-29 17:07

H2：=INDEX(TEXTSPLIT($G2,{"["," ","]"}),2)
I2：=TEXT(INDEX(TEXTSPLIT($G2,{"["," ","]"}),3)-0.2,"0.2外;0.2内")

mjm04 · 发表于 2024-10-29 17:21

WPS-正则提取

C2单元格：
=REGEXP(A2,"\[\K\d+")
下拉

J2单元格：
=HSTACK(REGEXP(G2,"\[\K\d+"),IF(REGEXP(G2," \K0\.\d+")*1>0.2,"0.2外","0.2内"),REGEXP(G2," \K0\.\d+"))
下拉

wtzxuexivba · 发表于 2024-11-1 00:07

C2单元格：=--REGEXP(A2,"(?<=\[).*(?=\])")

你是那块小饼干 · 发表于 2024-11-1 10:06

=TEXTBEFORE(TEXTAFTER(A2,"["),"]")

复制代码

中括号

=TEXTSPLIT(TEXTBEFORE(TEXTAFTER(G2,"["),"]")," ",,TRUE)

复制代码

pgp5866 · 发表于 2024-11-1 11:11

=REGEXEXTRACT(G2,"\[\K\d+")

复制代码

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

[求助] 这个提取文本怎么弄？

评分

评分