You can use the SUBSTRING COMPARISON TEST to determine if the string "Dropped" appears anywhere in the record by choosing suitable values for p1 and m1. The description starts on page 112 of my copy of DFSORT Application Programming Guide.
> -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Ron Thomas > Sent: Tuesday, February 07, 2017 6:45 AM > To: [email protected] > Subject: DFSORT Extract records > > Hi . We have a below file , and here i want to extract all records that have > a string value > "Dropped" , the value is not coming in to any fixed position . > Could some one let me know how to get the records extracted ? > > > 00000003~94800.00~USD~Process~Submitted~~F00000 > 00000004~15640.00~USD~Process~Submitted~~F00000 > 00000005~27200.00~USD~Process~Submitted~~PS0323 > 00000006~2193.00~USD~Process~Submitted~~USHSR1~ > 00178909~750.00~USD~Process~Dropped~Invalid Buyer ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
