将累赘的数字去掉，但是不能误删日期的数字

summerlcb

请问绿色单元格函数如何填写，才能将黄色单元格内的数据，名字后面的数字1和0去掉，但是不能误删日期的数字。

无关岁月

1. =IFNA(REGEXREPLACE(A1,"(?<=[一-龟])\d+",),"")

复制代码

leepoison

1. =IFERROR(REGEXP(A1,"(?<=[一-龟])\d+",2),"")

复制代码

尘土1

=REGEXP(A1,"(?<=\p{Han})[0-9]",2,"")

boyuanoffice

1. =IFERROR(REGEXP(A1,"(?<=\p{Han})\d+",2),"")

复制代码

yellowhawk

无关岁月 发表于 2024-6-11 10:08

这个正则厉害！！！

hugeinfo

一火车
=IFERROR(REDUCE("",TEXTSPLIT(A1,,"；"),LAMBDA(x,y,TEXTJOIN(";",,x,TEXTBEFORE(y,"：")&"："&TEXTJOIN("、",,IFERROR(TEXTSPLIT(TEXTAFTER(y,"："),ROW($1:$10)-1,"、"),""))))),"")

mykitami

=LET(a,TEXTSPLIT(A1,"：","；",1),b,TAKE(a,,-1),c,DROP(REDUCE("",b,LAMBDA(m,n,VSTACK(m,REDUCE(n,SEQUENCE(10)-1,LAMBDA(x,y,SUBSTITUTE(x,y,)))))),1),IFERROR(TEXTJOIN({"：";"；"},1,HSTACK(TAKE(a,,1),c)),""))

mykitami

看来以后有时间要好好学习 下正则了

jisijie630

=IF(A1="","",TEXTJOIN({"、","；"},1,LEFT(TEXTSPLIT(A1,,{"、","；"}),LEN(TEXTSPLIT(A1,,{"、","；"}))-MMULT(TEXT(RIGHT(TEXTSPLIT(A1,,{"、","；"}),{1,2}),"1;;1;!0")/1,{1;1}))))