How to remove leading zeros in DataStage

Question

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

+3

Ley gail May 07 '15 at 11:47

1 answer

Barak kedem · Accepted Answer · 2015-05-07T11:48:35+0000

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