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 ?

score 5 · Accepted Answer · answered May 07 '15 at 11:48

5

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

answered May 07 '15 at 11:48

Hard Worker

1 Answers1