WPS正则表达式练习用法

我的城市你来过

20240618字段提取
=MAP($E$9:$E$21,LAMBDA(x,REGEXP(x,"(?<=司-).*?(?<=座)")))
=MAP($E$9:$E$21,LAMBDA(x,REGEXP(x,"(司-|(?<=座).+)",2,"")))

我的城市你来过

20240618记录
=REGEXP(A12,"(\d+)(?="&{"天","时","分","秒"}&")")&""
=REGEXP(A12,"(\d+)(?=[天时分秒])")
=REGEXP(A12,"\d+")
=REGEXP(A12,"[^(?=(天|时|分|秒))]")
=REGEXP(A12,".(?<!(天|时|分|秒))")
=REGEXP(A12,".(?!(天|时|分|秒))",2,".")

我的城市你来过

20240622合并内容
=REGEXP(REGEXP(TEXTJOIN("@",,SCAN("",SORT(UNIQUE($B$2:$B$88),,-1),LAMBDA(x,y,TEXTJOIN("、",,FILTER($A$2:$A$88,$B$2:$B$88=y),y)))),"(、(?=\d))",2,"均为"),"@",2,""&CHAR(10))

我的城市你来过

20240622合并单元格数字中文拆分
=MAP(SCAN("",$A$1:$A$24,LAMBDA(x,y,IF(y<>"",y,x))),LAMBDA(x,REGEXP(x,"(\d+)(\W+)",2,"\"&COLUMN(A1))))

我的城市你来过

20240622书名作者出版社提取
=REGEXP(A1,"[^\s[［\d-]+")


just=REGEXP(A1,"[一-龟\．，？]+")


OK=LET(x,REGEXP(A1,"[一-龟\．，？·]+"),FILTER(x,(LEN(x)<>MIN(LEN(x))*((COUNTA(x)=4)))))

ggmmlol

我的城市你来过 发表于 2024-6-22 19:03
20240622书名作者出版社提取
=REGEXP(A1,"[^\s[［\d-]+")

WPS公式：
=REGEXP(A1,"^[^ \[［]+|\S(.+?)(?=\s\S+出版)|\S+出版\D+|[\d-]+(?=\n?$)")

EXCEL的正则提取函数返回的是一个竖向一维数组，需要用TOROW转为水平数组：

=TOROW(REGEXEXTRACT(A1,"^[^ \[［]+|\S(.+?)(?=\s\S+出版)|\S+出版\D+|[\d-]+(?=\n?$)",1))

20240622练习-03.rar (14.46 KB, 下载次数: 2)

2024-6-23 04:22 上传

点击文件名下载附件

我的城市你来过

20240623姓名手机地址重排
=SORTBY(REGEXP(A2,"[一-龟0-9]+"),LENB(REGEXP(A2,"[一-龟0-9]+")),1)

我的城市你来过

20240623内容提取
=EVALUATE(IFNA(REGEXP(A2,"[0-9.+*]+(?=\s*W)"),0))

我的城市你来过

20240623练习提取
=TAKE(REGEXP(A1,"(?<=-).+?(?=[\(\（.])"),,1)

我的城市你来过

20240623提取练习
=REGEXP(A1,"(?<=，)[一-龟·]+(?=，p)")