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?
Have to remove 0's from varchar field
Moderators: chulett, rschirm, roy
You can also do a TRIM(In.Column,'0','L') which will remove all leading "0" characters from your column.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
It is assumed, Amarpreet has given the values for single filed in order seperated by comma and not all together a single field value.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
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'