Conversion of String to Negative

[Akeelah]

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.....

[ChrisTX]

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 · Accepted solution]

@Akeelah does the attached workflow help?

[RobertOdera · Accepted solution]

Hi, @Akeelah 

Try the below, cheers.

[Raj · Accepted solution]

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

this should solve the issue