how to strip leading 0's from numeric data

tcat2000 · Post by **tcat2000** » Thu Jun 02, 2005 11:40 am

Hi,

does anyone know how to strip leading zeros from numeric fields.

ie. 021121234 - > 21121234

thanks

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 02, 2005 11:44 am

If you move it to a numeric field, it will automatically do it for you.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 02, 2005 4:14 pm

You can perform arithmetic on it. For example add zero to it. DataStage returns the shortest possible string when arithmetic results are presented.

Other approaches use the Trim() function, the Fmt() function, or the Iconv() function, not to mention reinventing the wheel by writing your own routine.

But arithmetic, or Sainath's solution (loading into an Integer column will automatically remove the leading zero), are the efficient mechanisms.