Use tr command in Filter property in seq file stage.

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
allavivek
Premium Member
Premium Member
Posts: 211
Joined: Sat May 01, 2010 5:07 pm

Use tr command in Filter property in seq file stage.

Post by allavivek »

Hi All,

Iam trying to use below command

tr -cd [:print:] in filter property of sequential file stage , to remove unprintabls in file.

It was throwing error "no record delimiter found ", but it was defined .

Other filter commands such as grep , head etc are working fine .

Is there any other i should use this command ?

Thanks
Vivek
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

I guess when you removed unprintable characters, that included line terminator characters too, so your record delimiter was gone before the stage read the tr output.
Choose a job you love, and you will never have to work a day in your life. - Confucius
allavivek
Premium Member
Premium Member
Posts: 211
Joined: Sat May 01, 2010 5:07 pm

Post by allavivek »

yep that's the reason .

Thanks..
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

So how did you handle this?
pandeeswaran
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Post by SURA »

It is always a good practice to comeback to the forum and say how the issue is resolved. It will help all of us to check when the help needed.

DS User
Post Reply