WPS正则表达式练习用法

我的城市你来过

20240530数据符号前后提取
=HSTACK(ARRAYTOTEXT(REGEXP($A2,"\d+(?=/)")),ARRAYTOTEXT(REGEXP($A2,"(?<=/| )\d+")))

我的城市你来过

20240530名字提取
=REGEXP($A4,"(?<=大区|地区)\W+(?=（)")

我的城市你来过

20240531格式转化
=UNIQUE(DROP(TEXTSPLIT(CONCAT(REGEXP(CONCAT($D$2:$D$4),"(?<=总部).+")),,{"：","、"}),1),FALSE)
=ARRAYTOTEXT(FILTER(CHOOSECOLS(HSTACK(A$2:A$4,$C$2:$C$4),COLUMN(A1)),MAP($D$2:$D$4,LAMBDA(x,REGEXP(x,$F2,1)))))

大区参与人员

=REGEXP(CONCAT($D$2:$D$4),"(?<=大区：).+(?=总部| )")

我的城市你来过

20240531地址信息拆分
=REGEXP(A2,"([一-龟]+|\d+)")
=HSTACK(REGEXP(A2,"([一-龟]+)"),REGEXP(A2,"([^一-龟\-]+)"))
=REGEXP(A2,"\p{Han}+|\d+")

我的城市你来过

20240531提取订单数量

=IFERROR(REGEXP(D2,"[\d.]+(?=斤)"),REGEXP(D2,"\d.+(?<=\/|\*).+(?<=盒)"))

我的城市你来过

20240531提取工号姓名
=REGEXP(SUBSTITUTES($A4,{"+","退款"," ","供应室","退费"},""),"(\w+)(\W+)",2,"\"&COLUMN(A1))


=REGEXP($A4,{"(\w+)","[^\w.+|退款| |退费]+"})

我的城市你来过

20240531字母内容提取
=SUBSTITUTE(CONCAT(REGEXP(B2,"(?<=Color|:).+([\w+)])")),"piece)"," + ")

我的城市你来过

20240531带*姓名身份证匹配
=CHOOSEROWS(FILTER($A$2:$B$6,MAP($A$2:$A$6,LAMBDA(x,REGEXP(x,$E2,1)))),COUNTIF(E$1:E2,E2))

我的城市你来过

20240531数据分段
=TEXTJOIN("-",,REGEXP(A1,"\d{4}"))

我的城市你来过

20240602正则替换
=EVALUATE(REGEXP(A2,"(\d+)\*(\d+)\*(\d+)",2,"(\1-\2)*\2*\3*0.02491/1000"))
=LET(m,REGEXP($A2,"\d+"),x,INDEX(m,,1),y,INDEX(m,,2),z,INDEX(m,,3),(x-y)*y*z*0.02491/1000)