WPS正则表达式练习用法

我的城市你来过

20240630练习
=LET(m,HSTACK(SCAN("",促销员工资表!$A$1:$A$84,LAMBDA(x,y,IF(y<>"",y,x))),促销员工资表!$C$1:$C$84,促销员工资表!$J$1:$J$84),o,CHOOSECOLS(m,1),p,CHOOSECOLS(m,COLUMN(B$1)),j,COUNT(FILTER(p,o=$A2)),INDEX(p,FILTER(MATCH($A2,o,)+j,j>1,MATCH($A2,o,))))

我的城市你来过

20240630练习提取
=REGEXP(A1,"[a-z.一-龟()\.*；， ,;/…]+|\[.+\]+")



OK版=REGEXP(A1,"([a-z/ ]+(?=\[|\s))|\[.+(?<![一-龟～])\]+|[a-z一-龟].+")

我的城市你来过

20240630练习1
=REGEXP(A1,".+(?=\d{11}.*+)")
=REGEXP(A1,"(\d{11}.*+)",2,"")

朱先飞

我的城市你来过 发表于 2024-6-30 12:35
20240630练习提取
=REGEXP(A1,"[a-z.一-龟()\.*；， ,;/…]+|\[.+\]+")

=REGEXEXTRACT(A1,"[a-z\s]+|(\[.+\])|[一-龟]+.+",1)。但提取结果分成了4部分，汉字前面的字母跟汉字连不到一起，麻烦大神改进一下，谢谢

我的城市你来过

朱先飞 发表于 2024-7-1 19:15
=REGEXEXTRACT(A1,"[a-z\s]+|(\[.+\])|[一-龟]+.+",1)。但提取结果分成了4部分，汉字前面的字母跟汉字连 ...

[a-z.一-龟]试下，我用的regexp你的是365，可能搜索规则不一样，你试试

我的城市你来过

20240701音标提取
=LET(x,CHOOSECOLS(REGEXP(A2,"[A-z 0-9.á+í]+"),{1,7,2,3,4,5,6}),HSTACK(CHOOSECOLS(x,1,2),VLOOKUP(INDEX(x,,3),Sheet2!A:B,2,0),CHOOSECOLS(x,4,5,6,7)))

=LET(x,CHOOSECOLS(TEXTSPLIT(TEXTJOIN("@",,REGEXP($A2,"[^,].+")),{"@",","}),1,7,2,3,4,5,6),HSTACK(CHOOSECOLS(x,1,2),FILTER(Sheet2!$B$1:$B$6,CHOOSECOLS(x,3)=CHAR(10)&Sheet2!$A$1:$A$6),CHOOSECOLS(x,4,5,6,7)))

=REGEXP(A2,"[A-z.0-9 +\\wáéíóú?]+")

我的城市你来过

20240704练习
=REDUCE(HSTACK("",$A$1:$B$1),$A$2:$A$4,LAMBDA(x,y,VSTACK(x,HSTACK(SEQUENCE(ROWS(TEXTSPLIT(OFFSET(y,,1),,"、"))),IF({0,1},TEXTSPLIT(OFFSET(y,,1),,"、"),y)))))

我的城市你来过

20240704练习2
=DROP(REDUCE("",$B$2:$G$2,LAMBDA(x,y,VSTACK(x,IF({0,1},TOCOL(OFFSET(y,1,,5),3),y)))),1)

=WRAPROWS(REGEXP(TEXTJOIN(",",,TOCOL(IF($B$3:$G$7<>"",$B$2:$G$2&","&$B$3:$G$7,\s),3)),"[一-龟0-9A-z]+"),2)

kjy520aia

强大！论坛伴我成长！

我的城市你来过

20240706练习01
=REGEXP(A2,"(?<=-)[A-z0-9.]+[KM]")
=REGEXP(A2,"(?<=-)(?!\d-).+(?<=K|M)")