按要求提取关键词

ych9999 · 发表于 2024-5-30 08:05

按要求提取关键词

龙逸凡 · 发表于 2024-5-30 08:22

=IFERROR(TEXTJOIN("、",,TOROW(REGEXP($A3,TEXTSPLIT(B$2,"、",)),3)),"否")

zjyk001 · 发表于 2024-5-30 08:25

=IF(LEN(A3)>LEN(SUBSTITUTE(A3,B2,"")),B2,"否")
=IF(LEN(A3)>LEN(SUBSTITUTE(A3,"技术","")),"技术、","")&IF(LEN(A3)>LEN(SUBSTITUTE(A3,"企业","")),IF(LEN(A3)>LEN(SUBSTITUTE(A3,"新三板","")),"企业、","企业"),"")&IF(LEN(A3)>LEN(SUBSTITUTE(A3,"新三板","")),"新三板","")

cnmlgb9998 · 发表于 2024-5-30 08:36

PQ 方案，又快又稳。。。。。。。

ych9999 · 发表于 2024-5-30 08:37

zjyk001 发表于 2024-5-30 08:25
=IF(LEN(A3)>LEN(SUBSTITUTE(A3,B2,"")),B2,"否")
=IF(LEN(A3)>LEN(SUBSTITUTE(A3,"技术","")),"技术、"," ...

首先非常感谢，但是最后一行的新三板都提取不出来。

我的城市你来过 · 发表于 2024-5-30 09:07

=TEXTJOIN("、",,FILTER(TEXTSPLIT(B$2,"、"),REGEXP($A3,TEXTSPLIT(B$2,"、"),1),"否"))

ych9999 · 发表于 2024-5-30 09:10

我的城市你来过发表于 2024-5-30 09:07
=TEXTJOIN("、",,FILTER(TEXTSPLIT(B$2,"、"),REGEXP($A3,TEXTSPLIT(B$2,"、"),1),"否"))

结果出错呀

hxj119 · 发表于 2024-5-30 09:11

=IF(ISNUMBER(FIND($B$2,A3)),$B$2,"否")

=TEXTJOIN("、",,IF(ISNUMBER(FIND(TEXTSPLIT($C$2,"、"),A3)),TEXTSPLIT($C$2,"、"),""))

我的城市你来过 · 发表于 2024-5-30 09:13

ych9999 发表于 2024-5-30 09:10
结果出错呀

你的版本太低了，得升级下。

ych9999 · 发表于 2024-5-30 09:17

hxj119 发表于 2024-5-30 09:11
=IF(ISNUMBER(FIND($B$2,A3)),$B$2,"否")

=TEXTJOIN("、",,IF(ISNUMBER(FIND(TEXTSPLIT($C$2,"、"),A3)) ...

非常感谢，应该是版本的问题

		自动登录	找回密码
密码			免费注册

[求助] 按要求提取关键词