Originally posted by: SystemAdmin

Hello everyone;

I have one question (newbie question), how i can delete non-numeric chars from a decimal data? For example i got the (' 383.7064628') and my desired result is 3837064628. In the map properties appear that my field is a decimal presentation and the item subclass is Number and the pad value is <SP>. I'm getting lost with this.

Thanks and regards from Colombia.
Cristian.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: TarunB

Sounds like you'll have to change your field definition to be something other than Decimal. One option is to use a Text field instead, and the map rule LEAVENUM.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: TarunB

Sounds like you'll have to change your field definition to be something other than Decimal. One option is to use a Text field instead, and the map rule LEAVENUM.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender