Elimnating Zero's

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pradeep_nov18
Participant
Posts: 92
Joined: Wed Mar 05, 2008 4:09 am
Location: chennai
Contact:
Contact pradeep_nov18

Elimnating Zero's

Post by pradeep_nov18 »

Hi Experts,

How to eliminate leading zero's for the integer:

Input Output
0000101-----101
0010023-----10023
0000045-----45


Can anyone help me on this?thanks in advance for your reply!
pradeep.v
Top
nani0907
Participant
Posts: 155
Joined: Wed Apr 18, 2007 10:30 am

Post by nani0907 »

use Trim function
Trim(cloumnname,'0','L')

It will trim leading zeros
thanks n regards
nani
Top
pradeep_nov18
Participant
Posts: 92
Joined: Wed Mar 05, 2008 4:09 am
Location: chennai
Contact:
Contact pradeep_nov18

Post by pradeep_nov18 »

Thanks nani it's working
pradeep.v
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”