Uipath does not recognize parentheses


I am picking up a integer from excel which includes parentheses. This means that the number is negative but it seems that when I save the integer into a variable it does not have the parentheses and therefore it is seen has a positive number. Does anyone know how to make sure that the parentheses are also included? See screen shot below.

Can you try taking from the excel as a string. If TestNumber Contains “(” then replace “(” with “-” and “)” with “” then you can convert the now perfect string using CInt(TestNumber). That should get you the desired outcome. I can build this out if you need it.

1 Like