Trim Function

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
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

Trim Function

Post by ds_is_fun »

Trim(DecimalToString(DSLink2.a,"fix_zero,suppress_zero"),"0","L")
How do "0" and "L" play a role here?
Top
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

L -> Leading
0 -> Char to trim

In short, it is to make '000012300' as '12300'.
Top
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

Post by ds_is_fun »

fix_zero,suppress_zero
Should take care of suppressing all leading and trailing zeros. So is that extra care?
Thanks
Top
Post Reply

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