How can I trim 3 leading zeroes of a decimal number

pebbles · Post by **pebbles** » Tue Apr 08, 2008 4:15 pm

I am trying to trim 3 leading zeroes from from a Varchar and decimal and can't seem to get it working.

kumar_s · Post by **kumar_s** » Tue Apr 08, 2008 4:18 pm

Can you give a example?
Do you have three leading zeros infront of Decimal converted to string?

pebbles · Post by **pebbles** » Tue Apr 08, 2008 4:30 pm

[quote="kumar_s"]Can you give a example?
Do you have three leading zeros infront of Decimal converted to string? ...[/qu

Below is a sample:

000320502227900616

kumar_s · Post by **kumar_s** » Tue Apr 08, 2008 4:54 pm

You Trim(Input.field,'0','L') in transformer as string.

ShaneMuir · Post by **ShaneMuir** » Tue Apr 08, 2008 4:55 pm

Will there always be 3 leading zeros? Also I don't see a decimal there? What formats are you going from and to (give lengths, precisions, scale)