I am trying to use the character data as numeric from the file I receive.
TOTAL LOSS IN - 139,454.00-
The value always comes at column 41. My shop has SYNCSORT.
I could manage few things like converting from csv to regular flat file and removal of low-values to spaces. As this is a new requirement and there is no other business logic involved I am trying this in sort. Can you guide me to resolve this?