read csv data

[187]

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

[alexnajm]

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

[caltang]

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.