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

Ask in Your Language 中文
#1

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

#2

是不是设置长度了 ？

#3

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

#5

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

#6

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

#7

@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)

#8

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

#10

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