Replacing values within fields

jr3011 · Posted: Fri May 15, 2009 6:19 pm

Is it possible to replace values within a field without looking at each character in the field. The commas or quotes can appear in any positon.

In my example i want to replace all commas and quotation marks with a question mark

Input file contains invoice-number (15 ch), description (23 Ch), and vendor-name (24 ch)

Input
invoice,"123456description,,"",1234567vendor"",name12345678901

Output
invoice??123456description?????1234567vendor???name12345678901

dbzTHEdinosauer · Posted: Fri May 15, 2009 6:29 pm

FINDREP would probably suffice.
Doc for July, 2008 DFSORT PTF (FINDREP, WHEN=GROUP, DATASORT, SUBSET, etc)

www.ibm.com/servers/storage/support/software/sort/mvs/ugpf/

there is a 'STICKY' in the DFSORT/ICETOOL forum that has links to all of DFSORT documentation.

jr3011 · Posted: Fri May 15, 2009 7:10 pm

Thanks Dinosauer,
The PTF (90013) is in the loop to be installed within the next couple of weeks. So, i guess i have to wait for that.

Thanks alot for your help.

Frank Yaeger · Posted: Fri May 15, 2009 9:47 pm

Here are two ways to do what you want.

With FINDREP (PTF UK90013 required):

jr3011 · Posted: Sat May 16, 2009 12:38 am

Frank,
Thanks for the response. You guys are great. I tried using the ALTSEQ method and it worked with one exception. My record contains some packed decimal fields, so it converted the '7F's to '6F's. Is it possible to define the fields (positions) i want to convert, or do i need to wait for the PTF and use the FINDREP method ?

Thanks for your help.
John Hagan

Frank Yaeger · Posted: Sat May 16, 2009 12:56 am

Yes, you can specify the positions you want to convert with both FINDREP and TRAN=ALTSEQ. For example, if you wanted to convert only 11-20 and 31-40, you could use: