DSXchange

I have a varchar field, which contains values like 00234,00980,.....

I have to remove all the 0's from the left of this value. my result should be 234,980,......
which function should I use in Datastage to achieve this?

Doing an arithmatic manipulation on a charcter forces it to be changed to an integer. Just try multiplying it by 1 that should work.

You can also do a TRIM(In.Column,'0','L') which will remove all leading "0" characters from your column.

Assuming the data is as shown in your post, you will have to separate the data based on the ',' delimiter before implementing the solutions suggested by Arnd and Guru. Rebuild the string, putting the ',' back in after the manipulation.

Rob

rwierdsm wrote:Assuming the data is as shown in your post, you will have to separate the data based on the ',' delimiter before implementing the solutions suggested by Arnd and Guru. Rebuild the string, putting the ',' back in after the manipulation.

Rob

It is assumed, Amarpreet has given the values for single filed in order seperated by comma and not all together a single field value.

Thanks, its working

Yes those were 2 separate values(just exmaple values). Used trim function, which is working just perfectly. Thanks a ton.....