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