1. Convert the decimal (or whatever it was) to String.
2. then trim '0's from left.
Trim(DecimalTostring(In.Col),'0','L')** These functions are available in transformer stage.
Like the Facebook Page & join Group
https://www.facebook.com/DataStage4you
https://www.facebook.com/groups/DataStage4you
https://twitter.com/datastage4you
https://groups.google.com/d/forum/datastage4you
For WHATSAPP group , drop a msg to 91-88-00-906098