How about something like (untested): ... | SORT sortspecs | UNIQUE ANYCASE uniqueranges MULTIPLE | TAKE n ...
Mike Walter Hewitt Associates Any opinions expressed herein are mine alone and do not necessarily represent the opinions or policies of Hewitt Associates. "Ian S. Worthington" <[EMAIL PROTECTED]> Sent by: "CMSTSO Pipelines Discussion List" <[email protected]> 10/27/2008 06:23 PM Please respond to "CMSTSO Pipelines Discussion List" <[email protected]> To [email protected] cc Subject UNIQUE n I need a way to do something like a SORT UNIQ but extracting n records not just the first/last one. I reckon I can do it with LOOKUP with a DROP n in the "add to" path. Is there an easier way? ian ... Ian S. Worthington, MBCS. me: http://isw.me.uk/ photos: http://gallery.isw.me.uk/ Dulce et decorum est pro patria mori, sed dulcius pro patria vivere, et dulcissimus pro patria biber. Ergo, bibiamo pro salute patriae. The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited. All messages sent to and from this e-mail address may be monitored as permitted by applicable law and regulations to ensure compliance with our internal policies and to protect our business. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by e-mail.
