How to remove the leading Zeros

arnie_nits · Post by **arnie_nits** » Mon Dec 31, 2007 7:49 am

Hi

I have got a varchar field. The records coming are like 0000006.50 and I want to get only 6.50. How is this possible?

Regards
Arnie

ArndW · Post by **ArndW** » Mon Dec 31, 2007 8:07 am

TRIM In.String '0' 'F' in a modify stage would do the trick

arnie_nits · Post by **arnie_nits** » Mon Dec 31, 2007 8:09 am

Is it possible it transformer stage??

regards
Arnie

ArndW · Post by **ArndW** » Mon Dec 31, 2007 8:12 am

Yes, the syntax is different; like the Server stage syntax. It is available in the PDFs or online help.

dspxlearn · Post by **dspxlearn** » Mon Dec 31, 2007 8:58 am

Since, it is a Varchar field, the same TRIM function will do the trick in Transformer stage aswell.

Code: Select all

Trim(Input_Col,'0','L')

Prabhakar · Post by **Prabhakar** » Tue Jan 01, 2008 11:40 pm

Trim(Input_Col,'0','L')

You can not convert 00015.50 to 15.50 when you doing decimal to decimal. The Trim function only work when you convert a column from decimal to Varchar then you can achieve the desired format you needed.

ArndW · Post by **ArndW** » Wed Jan 02, 2008 4:02 am

Prabhakar - but he stated in his original post that he had a VarChar() column.