如下:只截取非英文部分
step1.1
STEP2.2
STEP 6.21
IPC01
JOINARRAY(split('aab$.%哒哒哒哒1111',"[^0-9]"),"") ---提取数字
JOINARRAY(GREPARRAY(split("step1.1", ""), regexp(item, "[0-9\\.]")), "")
测试OK
其中一个方法,字符串需符合末尾是数字
replace("retyouy5.67",left("retyouy5.67",INARRAY(INDEXOFARRAY(GREPARRAY(split("retyouy5.67",""),item*1=item),1),split("retyouy5.67",""))-1),"")