Alteryx Designer Desktop Discussions

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

Conversion of String to Negative

Akeelah
7 - Meteor

Hi,
I am trying to convert the following strings ( -34,-45,-76) to integer
The select tool is showing error "-34 is not recognized"

 

And I tried to replace "-"

 

IF Contains([Min Temp1], "-") THEN
Replace([Min Temp1],"-",' ')

ELSE ([Min Temp1])

ENDIF

 

 

Output = ?34 , ?45.....

4 REPLIES 4
ChrisTX
15 - Aurora

You mentioned "strings".  Is the text     -34,-45,-76     all in one column, one row?

 

Or is the data in separate rows in your data source, like

    Min Temp1

     -34

     -45

    -76

 

?

 

aatalai
14 - Magnetar

@Akeelah does the attached workflow help?

RobertOdera
13 - Pulsar

Hi, @Akeelah 

 

Try the below, cheers.

 

For_Akeelah.png

Raj
15 - Aurora

@Akeelah 
REGEX_Replace([Field1],"-","")

this should solve the issue

Labels