正则提取相应数据

江林

根据左边的数据，得出右边的数据，最好用REGEXP公式，谢谢！

学习js宏

=REGEXP(A3,"[^ ]+") 第二列带括号自己处理一下就好了第二列也没必要用正则=REGEXP(C3,"\d+\.\d")

spaghetti8

=REGEXP($A1,"ZH\d+",0)
=--REGEXP($A1,"(?<=\()\d+\.\d+(?=\))",0)
=--REGEXP($A1,"(?<= )\d+(?= )",0)
=TRIM(REGEXP($A1,"CTL.+$|CT\d",0))

wbjjzhu

不是很完美的答案

1. =REGEXP(A1,"(ZH\d{2})|(\d+\.\d+)|(\d+(?=\s))|(CT\d{1}|CTL\d{1}\(\d+\))")

复制代码

Doris丶煉獄Hà

=REGEXP($A1,"ZH(\d+)")
=REGEXP($A1,"(?<=\()\d+\.\d+(?=\))")
=REGEXP($A1,"(?<= )\d+(?= )")
=REGEXP($A1,"(CTL\d+\(\d+\))|(CT\d+)")

我的城市你来过

=REGEXP(A1,"[A-z0-9.]+(\([0-9.]+\))?")

我的城市你来过

sunya_0529

如下图所示——

1. =IFERROR(REGEXP(A1,{"\w{2}\d{2}","\d+\.\d+","(?<= )\d+(?= )","\w+\d+\(\d\)"}),REGEXP(A1,"(?<=\w{2}\d{2}\()\w+\d+"))

复制代码