WPS正则表达式练习用法

我的城市你来过

20240603地址拆分
=REGEXP($B2,{"(\W+?(?<=省|市|区))","((?<=省|市)\W+?(?<=州|市|县|区))","((?<=市|县|区)\W+?(?<=市|区|镇|乡|街道))"})

我的城市你来过

20240603名址分级拆分
=REGEXP(B2&"@","[\W|\d]+?[?=省|市|州|旗|县|区|乡|镇|村|道|@]")

我的城市你来过

20240603获取门牌号
=REGEXP(A3,"\W+|\d+?[?=^弄|路|村|号|室]+")

我的城市你来过

20240603提取门牌号信息
=REGEXP(CONCAT(REGEXP($A1,".+(?=－－－)")),"[\W|\d]+?(?<=镇|村|路|弄|号|室)")

我的城市你来过

20240603条件求和
=SUM(REGEXP(REGEXP(CONCAT($A$2:$B$10),$E4,2,"\"),"(?<=\\).\d+")*1)

我的城市你来过

20240603提取供应商
=INDEX(REGEXP(A2,"[^#].\W+?(?=-|#)"),,2)

我的城市你来过

20240603规整收件人信息
=REGEXP(CONCAT(SUBSTITUTES(RIGHT(REGEXP($A2,"((?=[^\n]).+\d{4}).\d+"),17),{" ","：","乐部","收"},"")),"(\W+)(\d+)",2,"\"&COLUMN(A1))

=SUBSTITUTES(REGEXP($A2,"(?=[刘万王朱李赵]).+"),{" ","："},"")

我的城市你来过

20240605提取日期
=ARRAYTOTEXT(REGEXP(A1,"[\d/|-]+"))

我的城市你来过

20240606车次时间提取
=ARRAYTOTEXT(REGEXP(A1,"[\d月\d日|\d次|:分]+"))

=ARRAYTOTEXT(REGEXP(A1,"[\d月日分次:]+"))

boyuanoffice

我的城市你来过 发表于 2024-6-6 09:32
20240606车次时间提取
=ARRAYTOTEXT(REGEXP(A1,"[\d月\d日|\d次|:分]+"))

根据正则中 [...] 中的符号是或的逻辑, 里面不需要加 | 和重复的 \d
=ARRAYTOTEXT(REGEXP(A1,"[\d月日次分:]+"))