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
How to eliminate leading zero's in Decimal type column value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Tue Feb 13, 2007 5:30 am
Re: How to eliminate leading zero's in Decimal type column v
DecimalToString(JOIN_OK.IMSI_BSCS,"suppress_zero")
-
- Participant
- Posts: 35
- Joined: Tue Feb 13, 2007 5:30 am