Trim a string

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
wblack
Premium Member
Premium Member
Posts: 30
Joined: Thu Sep 23, 2010 7:55 am

Trim a string

Post by wblack »

Is it possible to call Trim using a list of characters to trim? I haven't been successfully parsing the Documentation.
William Black
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Not using the Trim() function - it can only specify one character to trim. However, you can use the Convert() function with a second argument of "". Or you could use nested Trim() functions if there are few characters to be trimmed or you need to trim only from one end, etc.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply