WPS正则表达式练习用法

我的城市你来过

20240706练习2
=REGEXP(A2,".*[ABCMNW/]+(?=\d)|(?=[0-9]).+(?=[KM])")

=REGEXP(A2,".*?[A-z/]+")

mjm04

leepoison 发表于 2024-5-25 17:21
=REGEXP(A1,"\D+",2)  凑个热闹

我也凑一下下

=REGEXP(A2,".{3}$")

我的城市你来过

20240709练习
=CONCAT(REGEXP(A2,"["&"^"&B2&"]"))

我的城市你来过

20240711练习1
提取日期=TEXT(REGEXP(A2,"[0-9-A-z-]+(?<=\d)"),"emmdd")

我的城市你来过

20240711练习2
=REGEXP(A1,"[^\s]+(?=$)")
=REGEXP(A1,"[一-龟]+(?!\s|[一-龟])")

everbest2015

感谢分享 学习了！

我的城市你来过

20240713练习1
=REDUCE({"人员","城市","数量"},$A$2:$A$10,LAMBDA(x,y,VSTACK(x,CHOOSE({1,2,3},y,TOCOL($B$1:$F$1),TOCOL(OFFSET(y,,1,,5))))))

我的城市你来过

20240713练习2
=LET(n,REDUCE({"编号","项目","人员"},$A$2:$A$6,LAMBDA(x,y,VSTACK(x,CHOOSE({1,2,3},y,TOCOL($B$1:$K$1),TOCOL(OFFSET(y,,1,,10)))))),FILTER(n,TAKE(n,,-1)<>0))

=REDUCE($A$1,UNIQUE($A$2:$A$6),LAMBDA(x,y,VSTACK(x,HSTACK(y,TEXTJOIN(",",,FILTER($B$2:$K$6,$A$2:$A$6=y))))))

=REDUCE($A$1:$K$1,UNIQUE($A$2:$A$6),LAMBDA(x,y,VSTACK(x,HSTACK(y,BYCOL(FILTER($B$2:$K$6,$A$2:$A$6=y),ARRAYTOTEXT)))))

我的城市你来过

20240713练习3

=LET(n,HSTACK(SCAN("",$A$5:$A$260&$B$5:$B$260,LAMBDA(x,y,IF(y<>"",y,x))),BYROW($D$5:$AH$260*1,COUNT)),REDUCE({"人员","次数"},UNIQUE(TAKE(n,,1)),LAMBDA(x,y,VSTACK(x,HSTACK(y,BYCOL(FILTER(TAKE(n,,-1),TAKE(n,,1)=y),SUM))))))

我的城市你来过

20240713练习4
=TOCOL(MAP(TOCOL(REGEXP(TEXTJOIN(" ",,MAP(TOCOL($A$1:$C$12,3),LAMBDA(x,REGEXP(x,".+(?<=\d{3})",2,)))),"[^\s]+")),LAMBDA(x,FILTER(x,FALSE=ISNUMBER(FIND(x,TEXTJOIN(",",,$G$1:$G$27)))))),3)

提取G列未出现人员