Recognise a negative value when sign appears after value

Posted over 2 years ago by Karen van Staden

Post a topic

Un Answered

Karen van Staden

Is there a way in Evo to recognise a value as negative when the sign appears after the value, in a .txt file?

See below.

0 Votes

1 Comments

Antonio Poggi posted over 2 years ago Admin

Hello Karen,

A quick trick would be to use a few preparation block to fix the data.

E.g. a Search/Replace block to fix the - symbol (by placing it in front of the number), followed by a Field Organiser to change the field type from text to decimal.

I've left an example here: https://daily.omniscope.me/Test/NegativeNumbers.iox/

0 Votes