WPS正则表达式练习用法

我的城市你来过

20240721练习1
=REDUCE($A$1:$C$1,UNIQUE(FILTER($A$2:$A$999,$A$2:$A$999<>"")),LAMBDA(x,y,VSTACK(x,HSTACK(y,BYCOL(FILTER($B$2:$C$999,$A$2:$A$999=y),SUM)))))
可实现自动汇总

我的城市你来过

20240721练习2
=VSTACK(HSTACK("姓名","科目","日期","*","数字"),SORT(FILTER(HSTACK(SCAN("",票据登记!$A$6:$A$286,LAMBDA(x,y,IF(y<>"",y,x))),票据登记!$G$6:$G$286,票据登记!$I$6:$K$286),(票据登记!$K$6:$K$286>0)*(LEN(票据登记!$J$6:$J$286)<10)),1))

我的城市你来过

20240721练习3

=REGEXP(A1,"\([0-9%A-z]+\)",2,"")

我的城市你来过

20240723练习1
=TAKE(UNIQUE(REGEXP(A2,"[一-龟]+?(?<=省|市|县|区)"),1),,3)

我的城市你来过

20240723练习2
=REGEXP(A2,"(\d+幢|\d栋).+")

我的城市你来过

20240723练习2
=IFERROR(TAKE(TOCOL(REGEXP(TEXTJOIN(",",,FILTER($H$2:$H$6,$I$2:$I$6<=$B2)),$C2:$E2),3),1),"落选")

我的城市你来过

20240725练习1

=TEXTJOIN("-",,REGEXP(A1,"[^-]{2}"))

我的城市你来过

2024072701练习1
=REGEXP(A1,"(?<==)?[A-z ]+$")

=REGEXP(A1,"[^=]+$")

我的城市你来过

20240727练习2
=TEXTJOIN(CHAR(10),,BYROW(IFNA(WRAPROWS(REGEXP(D2,"[^。]+"),2)&"。",""),CONCAT))

我的城市你来过

20240730练习01
=IFNA(LET(a,CONCAT("第",ROW($A5),"行"),b,FIND(a,C$4),IF(ISNUMBER(b),SUBSTITUTE(REGEXP(MID(C$4,b+LEN(a),3),"\*\d+"),"*",)*C$2,"")),C$2)