All reasonable answers, Frank, but the "awk" script proposed in one of the replies to the OP's question will do it right now with no fuss, no muss, problem solved already. Floating fields like the OP gave as an example are perfect targets for regular expression pattern matching.
What you could seriously consider as a genuine enhancement would be regular expression pattern matching (like "awk" and "perl") for SORT FIELDS, as opposed to fixed-position matching. IIRC, there is even a GNU library you could link in to perform the matching for you (regexp, if memory serves, but I could be wrong about that name). Just a thought. Peter -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 8:14 PM To: [email protected] Subject: Re: SORT help - to split by delimiters Tony Babonas wrote: >Nah, Yaeger is always one step ahead......... > >I should have added: > >OUTREC OUTFIL=ORPHANS,SAVE Tony, That would be: OUTFIL FNAMES=ORPHANS,SAVE But I'm guessing that John's point is that the .99 values are only an example and other values (.00 to .99) would actually be present, and those values would end up NOT being aligned by the .99 conditions. If there really only were .99 values, then DFSORT's IFTHEN function could be used to align everything in one pass and one output data set rather than creating multiple output data sets that would need to be combined (replacing multiple OUTFIL INCLUDEs is one of the more efficient uses of IFTHEN). IFTHEN can be used to do this kind of alignment in limited situations, but in this case it appears there's too much variability in the delimited field layouts for that to be practical. Although if I knew all of the possibilities for the record layouts, I might be able to come up with an IFTHEN solution. Frank Yaeger - DFSORT Team (IBM) _ This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
