TRIM leading zeros

hargun · Post by **hargun** » Fri Oct 25, 2013 10:42 am

hi,

i am getting column name acct_num as varchar(23) from source as DB2 stage and loading as it to target oracle table as acct_num varchar(30).

my job design is

DB2 STAGE.........xfm...............oracle stage

the data i m getting like this 00000000000000000664373.
i want to trim the leading zeros and want 664373 as output

in transformer i use trim(acct_num) but doesn't work.

please help me on this.

chulett · Post by **chulett** » Fri Oct 25, 2013 11:08 am

You have to tell it WHAT you want trimmed - by default it trims spaces. And you should also ensure you specify "leading".

hargun · Post by **hargun** » Fri Oct 25, 2013 11:57 am

Thanks chulett, I tried by giving leading and it works fine.