Trim leading zero's
Posted: Tue Jun 08, 2010 11:23 am
Hi All,
I have an requirement to obtain the pricevalue from Oracle(Decimal 11,2) to create an dataset and this will be the source of MQSeries(JDA is the target system).
Eg:Input
00000000049.99
00000000159.90
Eg:Output
49.99
159.90
I just need a output as above,Please let me know your inputs on this.
Thanks,
Satheesh
I have an requirement to obtain the pricevalue from Oracle(Decimal 11,2) to create an dataset and this will be the source of MQSeries(JDA is the target system).
Eg:Input
00000000049.99
00000000159.90
Eg:Output
49.99
159.90
I just need a output as above,Please let me know your inputs on this.
Thanks,
Satheesh