Ltrim in load statement

[mhapanka]

Hi guys,

I have a field named "Product" that has  numbers which start with zeroes that I want to get rid of.

For example, some of the entries in this field are:

0000002344

00000213456

00000000023

I want to get rid of the zeroes and keep only the numbers

2344

213456

23

and I want to name this new column as "PRODUCT" and I want to do this under a load statement. not in the SQL that extracts this column. I tried a Ltrim but it didnt work

Can someone help me with the code?

[sunny_talwar · Accepted solution]

Try this

Replace(LTrim(Replace(PRODUCT, '0', ' ')), ' ', '0') as PRODUCT

[mhapanka]

The field name is in lowercase that I want to rename in uppercase.

do you mean:  Replace(LTrim(Replace(Product, '0', ' ')), ' ', '0') as PRODUCT ?

[sunny_talwar]

sure

[nsetty]

Num(Product) AS PRODUCT

[mhapanka]

i also want to convert thefield " prodduct" to text at the same time, how can i incorporate that in the code you provided?

[sunny_talwar]

May be this

Text(Replace(LTrim(Replace(Product, '0', ' ')), ' ', '0')) as PRODUCT