Removing leading '0' while decimal to varchar conversion

udayanguha · Post by **udayanguha** » Tue Mar 24, 2015 7:17 pm

Hi,
I have a decimal field of length (38,0) in my source table. In the target I want to put it as a varchar field.
I am using the TRIM function to remove leading '0's from the source field but '0's are not getting removed. Now I am using DecimalToString function which is working fine.
But I am still curious to know why trim function below is not working.

trim(field,"0","L")

ray.wurlod · Post by **ray.wurlod** » Tue Mar 24, 2015 10:40 pm

Probably there are non leading zeroes because the actual leading character is a space (" ") occupying the sign position.

udayanguha · Post by **udayanguha** » Wed Mar 25, 2015 6:57 am

I think you are right Ray, because I have a leading space for sign. So that means I first need to remove leading space and then leading '0's or rather stick to DecimalTo String with suppress zero.

Thanks Ray. I during this whole time saw this leading Space in the file and it never struck to me that '0's are not leading now. My bad!!

qt_ky · Post by **qt_ky** » Wed Mar 25, 2015 6:59 am

Also keep in mind that negative numbers will lead with a negative sign, not a space...

weiyi_will · Post by **weiyi_will** » Fri Jun 26, 2015 1:10 am

I ever avoided the leading zero issue by use VarChar from reading data from DB.

DSXchange

Removing leading '0' while decimal to varchar conversion

Removing leading '0' while decimal to varchar conversion

Re: Removing leading '0' while decimal to varchar conversion