Convert String with negative sign to Math Numeric

[CHo]

Hi. I'm uploading a text file into JDE usin a UBE. I'm using B98220d, parse delimited string to load the file. There is one numeric field in the file. It has a negative sign in front of the field. I've tried to ltrim the first character (negative sign) and then use Convert String to Math Numeric, but it won't convert. How do I get rid of the negative sign?

 

[Zaki Ahmed]

Try using ABS() function under GENERAL FUNCTIONS. For example:


FC Output = abs([FC Input])

 

[CHo]

The problem was not with the sign. The field was the last field in the record of the text file. There was a carriage return at the end of the field. I used BSFN Remove Illegal Characters from String and then converted string into math numeric.