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+11110…

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

Eric_Wong_Test (Eric Wong) April 9, 2021, 3:46am 3

You can use this

1 Like

Forum Engagement Daily Reports

Split the equation and find the value in other table

Topic		Replies	Views
Split the equation and find the value in other table Studio activities , question	4	778	April 15, 2021
Issue in Split Help activities	15	1351	February 10, 2020
Split dynamical string Help	7	5126	October 25, 2017
How to extract specific part from a string using specific separator and add those string in an array/collection and loop through it Academy Feedback	15	1920	September 15, 2020
How to get all the numbers seperatly from string Help activities , variable , string , question , data_manipulation	9	1174	December 2, 2019