Removing newline and tab characters in a string

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Naveen
Premium Member
Premium Member
Posts: 15
Joined: Sat Jan 07, 2006 10:51 pm

Removing newline and tab characters in a string

Post by Naveen »

Pls let me know the function how to remove newline and tab characters in a string
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Convert them to "".

Code: Select all

Convert(Char(9):Char(10),"",InLink.TheString)
More efficient would be to initialize a stage variable to Char(9):Char(10) and use the stage variable name as the first argument to Convert().
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”