WPS正则表达式练习用法

edwin11891

我的城市你来过 发表于 2024-6-23 18:15
20240623提取练习
=REGEXP(A1,"(?

非常感谢！提一个小小建议，在发帖提供资料时，最好配一张截图，比较直观。

我的城市你来过

20240624提取求和练习1
=EVALUATE(TEXTJOIN("",,SUBSTITUTE(REGEXP(B2,"(?<=订票费:)[-0-9.x=]+(?==)"),"x","*")))

我的城市你来过

20240624提取练习
=REGEXP(A1,"(.+(?=\.))|\.\w+")

我的城市你来过

20240624提取练习3
地址电话=LET(x,REGEXP($A2,"([\d-]+(?![一-龟\d\s\#-]))"),HSTACK(REGEXP($A2,x,2,""),x))
开户行=REGEXP(D2,"[一-龟]+|[\d-]+")

我的城市你来过

20240624文本校对
=LET(x,REGEXP(B2,"[^、，]+"),FILTER(x,FALSE=ISNUMBER(FIND(x,$A2)),"无变化"))

我的城市你来过

20240624练习04
=CHOOSECOLS(REGEXP(A1,"_[一-龟]+"),-1)
=REGEXP(A1,"(?<=\_).[一-龟]+(?!.)")

我的城市你来过

20240625数透表提取
=WRAPROWS(TEXTSPLIT(TEXTJOIN(",",,LET(x,TEXTJOIN("，",,$A$1:$A$6),y,WRAPROWS(REGEXP(x,"[一-龟]+|[0-9.]+"),2),SCAN(0,UNIQUE(INDEX(y,,1)),LAMBDA(m,n,TEXTJOIN(",",,HSTACK(n,SUM(IF(INDEX(y,,1)=n,INDEX(y,,2)*1,0)))))))),","),2)

我的城市你来过

20240627练习数组重构
＝REDUCE(HSTACK($A1,"次数"),UNIQUE(TEXTSPLIT(TEXTJOIN(",",,$A$2:$A$4),,",")),LAMBDA(x,y,VSTACK(x,HSTACK(y,SUM(--ISNUMBER(FIND(y,$A$2:$A$4)))))))

＝REDUCE($H$1:$I$1,$I$2:$I$5,LAMBDA(x,y,LET(m,OFFSET(y,,-1),n,CHOOSE({2,1},y,TEXTSPLIT(m,,",")),VSTACK(x,n))))
＝
REDUCE($A$1:$B$1,$B$2:$B$5,LAMBDA(x,y,LET(m,OFFSET(y,,-1),n,IF({1,0},y,TEXTSPLIT(m,,",")),VSTACK(x,n))))

我的城市你来过

20240627练习提取
=LET(x,TRANSPOSE(WRAPCOLS(REGEXP(REGEXP(TEXTJOIN(",",,$B$3:$R$4),"((?<=：)[0-9]+)",2,""),"[A-z0-9-一-龟]+"),COLUMNS($B$2:$R$2))),VSTACK(UNIQUE(CHOOSEROWS(x,1),1),UNIQUE(CHOOSEROWS(x,2),1)))

我的城市你来过

20240628地址规整
=REGEXP(TEXTJOIN(" ",,REGEXP($B2,"(?<=\w\s).+(?!\s)")),"[^ ]+")


=REGEXP($B2,"(?<=\s)[一-龟0-9]+")