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

eimon · April 9, 2021, 3:23am

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
Var1= 11110004
Var2= +
Var3= 11110005
Var4= -
Var5= 11110002
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

prasath_S · April 9, 2021, 3:35am

Hi @eimon

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

Eric_Wong_Test · April 9, 2021, 3:46am

You can use this

eimon · April 9, 2021, 4:14am

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

prasath_S · April 9, 2021, 4:18am

Have you tried my pattern

It will extract all the numbers

Eric_Wong_Test · April 9, 2021, 4:28am

eimon · April 9, 2021, 5:12am

@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 · April 9, 2021, 5:17am

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 · April 9, 2021, 5:21am

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

eimon · April 9, 2021, 5:36am

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

prasath_S · April 9, 2021, 5:59am

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 · April 9, 2021, 6:31am

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