Recognise a negative value when sign appears after value : Omniscope Help Center

Start a new topic

Recognise a negative value when sign appears after value

Karen van Staden

started a topic 9 months ago

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.

1 Comment

Antonio Poggi

said 9 months ago

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/