DSXchange

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

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

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!

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

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

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,