求高手指教，如何将表格中的长，宽和高分别提取出来，用分列提出来不准，最好用函数

zzf1113

请教高手，如何将表格中的长宽高分别提取出来。如只有长宽，就提取长宽，如只有直径的，就提取直径数字就行了。求高手把公式写在表格里，谢谢了

leepoison

=REGEXP(LET(a,TEXTSPLIT(A2,"/"),FILTER(a,REGEXP(a,"\*|φ|X ",1))),"\d+\.*\d*")

zzf1113

leepoison 发表于 2025-4-15 22:46
=REGEXP(LET(a,TEXTSPLIT(A2,"/"),FILTER(a,REGEXP(a,"\*|φ|X ",1))),"\d+\.*\d*")

大师，这个是取长还是宽的，这个我放表格中没有出来数据，能在我的表格中展示一下公式吗，谢谢

mykitami

=LET(_a,IFERROR(TEXTBEFORE(A2,"CM",-1,1,),A2),_b,IFERROR(TEXTAFTER(_a,"/"),_a),TEXTSPLIT(_b,TEXTSPLIT(_b,VSTACK(SEQUENCE(10)-1,"."),,1),,1))

下拉

wbjjzhu

1. =REGEXP(REGEXP(A2,"[\d.* X]+(?=(CM|cm))"),"[\d.]+")

复制代码

智商欠费的狗蛋

试一下这个Excel插件ExcelFlow，大部分都能提取出来，如果再优化一下指令，应该都能提取。

cnmanljl

B2=TEXTSPLIT(CONCAT(TAKE(REGEXP(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"CM",""),"X","*")," ",""),"(\d+(\.\d+)?)(\s*[*]\s*)(\d+(\.\d+)?)|(\s*[*]\s*)(\d+(\.\d+)?)|(?<=φ)\d"),,2)),"*")

cnmanljl

B2==TEXTSPLIT(CONCAT(TAKE(_wpsfn.REGEXP(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"CM",""),"X","*")," ",""),"(\d+(\.\d+)?)(\s*[*]\s*)(\d+(\.\d+)?)|(\s*[*]\s*)(\d+(\.\d+)?)|(?<=φ)\d"),,2)),"*")

无关岁月

1. =REGEXP(@REGEXP(A2,"(?i)[.\d]+(c?m?\s?(\*|X)\s?[.\d]+)+|φ\K\d+"),"[.\d]+")

复制代码

zzf1113

感谢各位大神的指导，已经解决了一个大问题，谢谢各位了！