Excel Automation in Studio X

Hi @flashdrive07

Check out the below process:


After Find/Replae value activity use the below syntaxes in Set Variable Value activity:

Set Variable Value-> column= System.Text.RegularExpressions.Regex.Match(foundX,"[A-Za-z]+").Value.Trim()

Set Variable Value-> cal= Convert.ToInt32((System.Text.RegularExpressions.Regex.Match(foundX,"(?<=[A-Z]+)[0-9]+").Value.ToString.Trim()))

Set Variable Value-> cal=cal+2

Set Variable Value-> output= String.Concat(column+Cal.ToString)

Note: cal is of DataType System.Int32. column is of DataType System.String. output is of DataType System.String.

Output:

Attaching the process flow of Studio X below:
Forum Task 2.zip (184.7 KB)

Hope it helps!
Regards

1 Like