That's a big 10-4 Liz and Gil. You don't learn until you read a manual, write a bit of code, test, repeat, rinse....etc
Scott On Wed, Mar 29, 2017 at 12:44 PM Lizette Koehler <[email protected]> wrote: > My intent was to show that a few more details would be helpful. > > > > And that there are options. > > > > And sometimes if posters are asked questions they can eventually answer > their > > own questions or understand what their process is going to do better. And > > reading manuals are always helpful when learning new functions. > > > > ;-D > > > > > > Lizette > > > > > > > -----Original Message----- > > > From: IBM Mainframe Discussion List [mailto:[email protected]] On > > > Behalf Of Sri h Kolusu > > > Sent: Wednesday, March 29, 2017 8:33 AM > > > To: [email protected] > > > Subject: Re: sort data extract > > > > > > >>> 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 > > -- Scott Ford IDMWORKS z/OS Development ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
