How to eliminate leading zero's in Decimal type column value
Posted: Thu Oct 18, 2007 5:27 am
Hi,
My requirement is to find the length of the Decimal datatype column which is coming from source(Sequential file).
When I am trying to find the length of this column I am not getting the actual legths, I am getting the datatype length.
Example: ABC column, declared as Decimal(15). Value is 103.
I am getting the length as 17 instead of 3. I think it's considering leading zero's and decimal.
How can I get the length as 3.
Here I can not change the datatype from decimal to integer.
How can I eliminate the leading zero's, Is there any function in Transformer?
Please help on this issue.
Thanks
My requirement is to find the length of the Decimal datatype column which is coming from source(Sequential file).
When I am trying to find the length of this column I am not getting the actual legths, I am getting the datatype length.
Example: ABC column, declared as Decimal(15). Value is 103.
I am getting the length as 17 instead of 3. I think it's considering leading zero's and decimal.
How can I get the length as 3.
Here I can not change the datatype from decimal to integer.
How can I eliminate the leading zero's, Is there any function in Transformer?
Please help on this issue.
Thanks