read csv data

Question

Hi Alteryx engineer,

I have met this problem, reading data from csv file and most of the column contains number with () standing for negative one and their datatype is v_string, i used toNumber() function then the value is converted to 0,  is there any quick way to get the correct number from these v_string fileds?

data like below:

123

(2332)

2323

caltang · Answer

You can provide some sample data for us to see what you're dealing with. Some of us will even make a workflow for you. So, can you provide some raw data please?

Otherwise just try @alexnajm 's solution on your own and see if it works for you.

alexnajm · Answer

ToNumber(TrimRight(Replace([Column],"(","-"),")"))