We have moved to www.dataGenX.net, Keep Learning with us.

Tuesday, June 16, 2015

trim leading 0's from decimal in DataStage


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