求助从表格中提取文本

真情作祟 · 发表于 2025-3-10 21:51

如表所示，把C列中的概念按顺序填入概念1、概念2至概念6中，C列中概念少于6个的按顺序填入，超过6个的超过部分不填

快乐王子238 · 发表于 2025-3-10 22:04

=TAKE(REGEXP(C2,"[一-龟]+",3),,6)
=REDUCE({"概念1","概念2","概念3","概念4","概念5","概念6"},C2:C4,LAMBDA(x,y,IFNA(VSTACK(x,TAKE(REGEXP(y,"[一-龟]+",3),,6)),"")))

wyslw2004 · 发表于 2025-3-10 22:12

=TAKE(TEXTSPLIT(C2,";"),,6)

mengrs · 发表于 2025-3-10 23:03

=TAKE(REGEXP(C2,"[^【】;]+"),,6)

你是那块小饼干 · 发表于 2025-3-11 08:00

=TEXTSPLIT(SUBSTITUTE(SUBSTITUTE(C2,"【",""),"】",""),";",,TRUE)

真情作祟 · 发表于 2025-3-11 08:03

谢谢，高手呀！

沈默00 · 发表于 2025-3-11 08:10

=IFNA(REDUCE(D1:I1,C2:C4,LAMBDA(x,y,VSTACK(x,TAKE(REGEXP(y,"[一-龟]+"),,6)))),"")

沈默00 · 发表于 2025-3-11 08:21

=IFNA(REDUCE(D1:I1,C2:C4,LAMBDA(x,y,VSTACK(x,TAKE(REGEXP(y,"[^{;,【,】}]+"),,6)))),"")
，如概念中出现字母或数字类的字符，这个更合适些

xtmyd5156 · 发表于 2025-3-11 11:24

=TAKE(REGEXP(C2,"[^\p{P}]+"),,6)

mjm04 · 发表于 2025-3-21 23:58

=TAKE(REGEXP(C2,"[一-龢]+"),,6)
下拉

一步到位
=IFNA(REDUCE({"概念1","概念2","概念3","概念4","概念5","概念6"},C2:C4,LAMBDA(a,b,VSTACK(a,TAKE(REGEXP(b,"[一-龢]+"),,6)))),"")

低版本不会写

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

[已解决] 求助从表格中提取文本

浏览过的版块