Thanks for all of the tips and suggestions. I did find one that, with a little modification, fit very well into my existing exec. Thanks again. Tom
-----Original Message----- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] Behalf Of Marty Zimelis Sent: Tuesday, November 28, 2006 10:07 AM To: [email protected] Subject: Re: Another PIPE how to -2 Tom, My approach would be a bit different from Colin's because I'm assuming that the number of terms inside parentheses is unknown. '*: |', 'split before /(/ |', 'split after /)/ |', 'b: between /(/ 1 |', 'change /,/ xff |', /* or any other character not in data */ 'f: faninany |', 'join * |', 'split /,/ |', 'change xff /,/ |', '*:', '?', 'b: | f:' Also not tested. Marty ____________________ Martin Zimelis Principal maz/Consultancy _____ From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Huegel, Thomas Sent: Tuesday, November 28, 2006 10:12 AM To: [email protected] Subject: Another PIPE how to -2 This list has the smartest guys around, so I have another PIPE how to. I have an input that looks like this: aaa=apple,bbb=ball,ccc=(cat,cow,candle),ddd=dog What I want is an output stem that looks like this: aaa=apple, bbb=ball, ccc=(cat,cow,candle), ddd=dog The input fields may be in any order and any (or none) may be inside parents. The trick is to be able to ignore the commas inside the parents. At first it looked easy just using SPLIT but I can't figure out how to handle the (cat,cow,candle) as one entity. Can anyone help? Tom __________________________________________________________________ << ella for Spam Control >> has removed VSE-List messages and set aside VM-List for me You can use it too - and it's FREE! http://www.ellaforspam.com <http://www.ellaforspam.com> _____ << ella for Spam Control >> has removed 8663 VSE-List messages and set aside 5810 VM-List for me You can use it too - and it's FREE! www.ellaforspam.com <http://www.ellaforspam.com>
