怎样提取备注里的特定信息

鹿一

如图，怎么快速提取备注里有项目名称文字，无项目时显示空值

ww87725244

1. =IFNA(TEXTBEFORE(TEXTAFTER(C5&" ","项目名称：")," "),"")

复制代码

part98

=IFNA(REGEXEXTRACT(C2,"(?<=项目名称：)\w+",1),"")

hxj119

低版本：
=IFERROR(TRIM(LEFT(SUBSTITUTE(MID(C2,FIND("项目名称：",C2)+5,50),"工程地点：",REPT(" ",99)),99)),"")

ww87725244

1. =IFERROR(MID(C2,FIND("项目名称：",C2&"工程地点：")+5,SUM(FIND({"项目名称：","工程地点："},C2&"工程地点：")*{-1,1})-5),"")

复制代码

mykitami

=IFNA(TEXTBEFORE(TEXTAFTER(C2,"名称：")," ",,,1),"")

伊可赛二

静听溪流

=IFNA(REGEXEXTRACT(C2,"(?<=项目名称：)\w+"),"")

我的城市你来过

=IFERROR(INDEX(TEXTSPLIT(REGEXP(C2,"(?<=项目名称：).+")," "),1),"")

木槿花西月锦绣

练习，凑个数，数据量有点少


=IF(ISERR(LEFT(INDEX(TEXTSPLIT(C2," "),1,3),4)),"",IF(LEFT(INDEX(TEXTSPLIT(C2," "),1,3),4)="项目名称",SUBSTITUTE(INDEX(TEXTSPLIT(C2," "),1,3),"项目名称：",""),""))








补充内容 (2024-6-22 20:47):
=SUBSTITUTE(IF(ISERROR(FIND("项目名称：",INDEX(TEXTSPLIT(C2," "),3))),"",INDEX(TEXTSPLIT(C2," "),3)),"项目名称：","")