Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

read csv data

187
8 - Asteroid

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

 
 

 

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

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

caltang
17 - Castor
17 - Castor

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.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors