I have a question for you, I believe you had stated before that there is additional information on each record following the IP address, so with your INREC statement, should you not have also coded for %04 a "ENDBEFR=" option to end that field? So wouldn't you code:
INREC IFTHEN=(WHEN=INIT, PARSE=(%01=(ENDBEFR=C'.',FIXLEN=3), %02=(ENDBEFR=C'.',FIXLEN=3), %03=(ENDBEFR=C'.',FIXLEN=3), %04=(ENDBEFR=C',',FIXLEN=3)), OVERLAY=(81:%01,%02,%03,%04)) SORT FORMAT=UFF,FIELDS=(81,3,A,84,3,A,87,3,A,90,3,A) OUTREC BUILD=(1,133) Al Nims Systems Admin/Programmer 3 Information Technology University of Florida (352) 273-1298 -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sankaranarayanan, Vignesh Sent: Wednesday, April 16, 2014 9:57 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Sorting CSV data that begins with an IP address Yup. I used this but the file gets all messed up. I'm sure it's not the right SYSIN for what I need to do. INREC IFTHEN=(WHEN=INIT, PARSE=(%01=(ENDBEFR=C'.',FIXLEN=3), %02=(ENDBEFR=C'.',FIXLEN=3), %03=(ENDBEFR=C'.',FIXLEN=3), %04=(FIXLEN=3)), OVERLAY=(81:%01,%02,%03,%04)) SORT FORMAT=UFF,FIELDS=(81,3,A,84,3,A,87,3,A,90,3,A) OUTREC BUILD=(1,133) - Vignesh Mainframe Admin -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Barry Sent: 16 April 2014 14:27 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Sorting CSV data that begins with an IP address Possibly the DFSORT INREC PARSE= feature might be usable to create your static-length, zone-decimal value field for the sort of a 'typical' IP address data-string in your CSV-format file. Scott Barry SBBWorks, Inc. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN MARKSANDSPENCER.COM ________________________________ Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN