How to remove leading zeros in DataStage

Question

I am trying to remove the leading zeros in the decimal field in a sequential file stage. what is the solution for this problem ?

Answer 1

The easy way is with : Trim(DecimalTostring(In.Col),'0','L')