How to add Carriage return in the swift file

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
pkll
Participant
Posts: 73
Joined: Thu Oct 25, 2012 9:45 pm

How to add Carriage return in the swift file

Post by pkll »

Hi All,

Can you please explain how to Add Carriage return in the swift file in data stage?

Thanks for your Advanced Help :D :D
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

May need more information but you would use the CHAR() function to represent an unprintable character. So for the carriage return you would use CHAR(10) wherever you needed to "add" it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How are you writing to the file? The Sequential File stage will ordinarily add a line terminator at the end of each line automatically.
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