Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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