How to split the equation(string type),if A1-A2 then var1=A1, var2=- , var3=A2

[prasath_S]

Hi @eimon

Use this regex pattern (use matches activity) it will only only extract numbers and store it in collection. \d*

[Eric_Wong_Test (Eric Wong)]

You can use this

[eimon]

@Eric_Wong_Test Thank you
But sometime the no has 5 or 6 digit too like 111001 or 11101 .

[prasath_S]

Have you tried my pattern

It will extract all the numbers

[Eric_Wong_Test (Eric Wong)]

[eimon]

@prasath_S Dear, Honestly i am working on “matches” activity ,but my first time using it and google it for how to declare on the Configure regular expression then lasting time on it. here are the updates

[prasath_S]

I think It should’nt be exactly 1 and should be like all in quantifiers

Or

You can select advanced and type the regex I gave

[Eric_Wong_Test (Eric Wong)]

In the For Each, Properties TypeArgument should change to System.Text.RegularExpressions.Match

[eimon]

@prasath_S Hello i got this result. But how to get the +/- sign .thank you for the previous answer.

[prasath_S]

Here is my solution,
This is the input let’s assume 11110004+11110005-11110002

1.first we split it using regex in for each.
2.in for each body first we get 11110004 so find corresponding value for this number (i.e) 60 as per your input.
3. Replace the original string (i.e) replace 11110004 with 60 using string.replace(youroldstring,newstring)
4.do similar to other numbers also in for each body.

In this ways instead of old values you get nee values with + and - in it

[eimon]

Dear @Eric_Wong_Test would you mind sending this file? because i dont get the same result like you . may be i was wrong setting in the Configure Regular expression. First , match is systems.collections.Generic.IEnumberable in Match activity and in for each loop Properties TypeArgument changed to System.Text.RegularExpressions.Match as you said

thank you

[ptrobot]

It should be a back slash \ (not a regular slash /). You can simplify the regex to:

\d+|\+|\-

[Eric_Wong_Test (Eric Wong)]

Is [0-9]

[eimon]

Hello @Eric_Wong_Test @ptrobot Thanks for the point. when i type "" in RPA , it appears as “￥”.

[ptrobot]

Ok, that’s strange. If you copy and paste my regex from previous post, do you still get the weird character?

[Eric_Wong_Test (Eric Wong)]

match.xaml (6.0 KB)

[Eric_Wong_Test (Eric Wong)]

Also, I think you are using Japan Keyboard, so you can’t be the \

[eimon]

yes eric @Eric_Wong_Test i am using jp keyboard. i found out my mistakes , i put the space after “(” it . thank you.

[eimon]

@ptrobot it just ok now. cause my keyboard is jp . thank you.