Hello smart users
I have three excel files as shown in the pic. I like to split the column of equation in Master file, like this
11110004+11110005-11110002 = Str_VarEquation
Sometimes the equation is has only + like 11110001+11110002
How to split those equations
I am implementing the calculated result in my logic as shown in the pic of
the green area (30,330,140)
Thanks in advance
Hello smart users
Use this regex pattern (use matches activity) it will only only extract numbers and store it in collection. \d*
@Eric_Wong_Test Thank you
But sometime the no has 5 or 6 digit too like 111001 or 11101 .
@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
I think It should’nt be exactly 1 and should be like all in quantifiers
You can select advanced and type the regex I gave
@prasath_S Hello i got this result. But how to get the +/- sign .thank you for the previous answer.
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
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
It should be a back slash \ (not a regular slash /). You can simplify the regex to:
Ok, that’s strange. If you copy and paste my regex from previous post, do you still get the weird character?
match.xaml (6.0 KB)
Also, I think you are using Japan Keyboard, so you can’t be the \
yes eric @Eric_Wong_Test i am using jp keyboard. i found out my mistakes , i put the space after “(” it . thank you.
@ptrobot it just ok now. cause my keyboard is jp . thank you.