issue with file read

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
bcarlson
Premium Member
Premium Member
Posts: 772
Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota

Post by bcarlson »

When you import your data, do you need the field to maintain formatting (i.e. keep the carriage retruns) or ignore them?

Brad.
It is not that I am addicted to coffee, it's just that I need it to survive.
chanaka
Premium Member
Premium Member
Posts: 96
Joined: Tue Sep 15, 2009 4:06 am
Location: United States

Post by chanaka »

Looks like you some of your input fields are having CR & LF characters. You can use a routine on that field to strip of unwanted characters in hte case business users are okay with that.
Chanaka Wagoda
Post Reply