DecimalToString() - with option 'suppress_zero'
Lets say Input.ColA = 00000004.00
Using the suppress_zero option will remove the meaningless zeroes.
DecimalToString(Input.ColA,"suppress_zero")
"4"
Lets take another example -
Input.ColA = 00012344.120
DecimalToString(Input.ColA,"suppress_zero")
"12344.12"
Tags
Datastage
I was recommended this web site by my cousin.
ReplyDeleteI'm not sure whether this post is written by him as nobody else know such detailed about
my problem. You are amazing! Thanks!