>>> Is SORT your only option? If not, REXX or SAS, or other languages can do this for you very easily.
Lizette, Sort can also do it quite easily. :) retired mainframer already provided that OP needs to look into "Substring Comparison Tests" which would give him the desired results. And just for the record DFSORT can meet all of your requirements listed. Thanks, Kolusu IBM Mainframe Discussion List <[email protected]> wrote on 03/29/2017 07:53:47 AM: > From: Lizette Koehler <[email protected]> > To: [email protected] > Date: 03/29/2017 07:54 AM > Subject: Re: sort data extract > Sent by: IBM Mainframe Discussion List <[email protected]> > > Is SORT your only option? > > If not, REXX or SAS, or other languages can do this for you very easily. > > Otherwise, > > You are stating you have a file LRECL=5000. Within this file, each > record has a STRING. > > Is it just one string you are looking for or multiple? > > The STRING could be as follows > > A,B,,X,Y,STRING,A,B, and so forth to the end of the record? > > A,B,,X,Y,STRING,A,B,STRING,C,X,Y,W,...,STRING and so forth to > the end of the record? > > The string only occurs ONCE in each record or more that once? > > Do you need any editing once it is found? > > Do you need to have the record number written where the string or > strings were found? > > Do you need the position written out where the string or strings were found? > > Do you need a new line written out when the string is found? For example: > > On line 20 in position 100 String STRING was found > > On line 20 in positions 100, 1001, 3000, 4500 string STRING was found > > Is the string, BINARY, CHARACTER, or other? > > A little more detail on your goal for this process will be helpful. > > > Lizette > > > > -----Original Message----- > > From: IBM Mainframe Discussion List [mailto:[email protected]] On > > Behalf Of Ron Thomas > > Sent: Wednesday, March 29, 2017 4:37 AM > > To: [email protected] > > Subject: sort data extract > > > > Hi , I have comma seperated VB block file of LRECL 5000, i need to > extract all > > records for those if there is a string like K170119. Could anyone > let me know > > how this to be done using sort jcl ? Thanks! > > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
