How can I Change Quote to Hyphen using SORT

NARAYANAM · New User Joined: 22 Sep 2006 Posts: 5

How can i CHANGE QUOTE TO HYPHEN using SORT. Please explain.

Thanking you,

Regards,
Narayanam Rama Rao.

William Thompson · Posted: Fri Jan 19, 2007 2:48 pm

Is the quote you want to change in fixed locations or just anywhere in the record?

NARAYANAM · New User Joined: 22 Sep 2006 Posts: 5

i want to change Quote to Hyphen using SORT in entire Sequencial file i.e., where ever QUOTE is present.

William Thompson · Posted: Fri Jan 19, 2007 3:15 pm

I don't think you will have any luck with any sort, maybe another utility will be more suitable.

Frank Yaeger · Posted: Fri Jan 19, 2007 10:13 pm

Narayanam,

You can use DFSORT's TRAN=ALTSEQ function to do what you want. I assumed you mean double quote " (X'7F') and hyphen (X'60') but you can use the hex values for any characters you need. I assumed your input file has RECFM=FB and LRECL=80, but the job can be changed for other attributes.