Start a new topic

Recognise a negative value when sign appears after value

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.


image


1 Comment

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.





Login or Signup to post a comment