Read Cell从Excel指定单元格获取数据会被自动截取掉

使用Read Cell从Excel指定单元格获取“ 01RK12345678”这样的数值,获取之后英文字符前后的数字会被删减掉 变成“0RK2345678”

是不是设置长度了 ?

@sunny360 Hi
will the order of character and digit same ?

没用单独设置过长度,长度设置在哪里查看

顺序没有变化,原来是O1RK15119070006,取出后变成了ORK5119070006

@sunny360
Use Replace Activity and Give the Pattern as \d(?=RK) it will Take one digit before and replace it with "" use another Replace and use the pattern (?<=RK)\d it will take next one digit of RK and replace it with "". Please find the attached workflow it will help you to understand.Sequence.xaml (5.1 KB)

方便的话,请发一下程序和excel,我帮您排查一下 谢谢

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.