Want to trim the leadin zero in a varchar

gssr · Post by **gssr** » Fri Nov 06, 2009 7:41 am

I need the following requirement:
Input Sample
000029.96
00000.00
00156.01
00007.12

Required output:
29.96
0.00
156.01
7.12

The dattypes varchar!!

i used the TRIM function to remove the leading zeroes...
TRIM (Link1,'0',"L")

But it is not working...
Can anyone suggest me a solution..

Thanks in advance

chulett · Post by **chulett** » Fri Nov 06, 2009 7:55 am

First off, what makes you think it is not working? What is your target field after the trim, another varchar or a decimal?

gssr · Post by **gssr** » Fri Nov 06, 2009 8:03 am

chulett wrote:First off, what makes you think it is not working? What is your target field after the trim, another varchar or a decimal? ...

I tried it, and the output is not changing. The target Column datatype is also Varchar!

chulett · Post by **chulett** » Fri Nov 06, 2009 8:07 am

And is your actual syntax more like TRIM(Link1.ColumnName,'0',"L") and what stage are you doing this in?

gssr · Post by **gssr** » Fri Nov 06, 2009 8:14 am

Yes ,i am using the same syntax ,And i am doing this in a Transformer Stage!

gssr · Post by **gssr** » Fri Nov 06, 2009 8:16 am

The Problem is solved ....Actually there are some spaces and hence i tried the followingand it is fine now!!

Trim((TrimLeadingTrailing(Link1.Column)),'0',"L")

Thanks for your comments,