How to eliminate leading zero's in Decimal type column value

[Sridhar Sivakoti]

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

[carmenh]

DecimalToString(JOIN_OK.IMSI_BSCS,"suppress_zero")

[DSguru2B]

You can use the AS_INTEGER() function and then take the length of that.

[Sridhar Sivakoti]

You can use the AS_INTEGER() function and then take the length of that.

Thanks DSguru2B.