Minor update: change the OUTPUT statement to leave off the trailing
commas, which are just noise.
Brian Nielsen
On Tue, 28 Nov 2006 11:01:08 -0600, Brian Nielsen <[EMAIL PROTECTED]
>
wrote:
>As an alternative to the other suggestions you could use a REXX stage:
>
>'| REXX KWSPLIT',
>
>
>The KWSPLIT REXX file contains:
>
>/* REXX stage to split at keywords */
>signal on error
>DO FOREVER
> 'READTO RECORD'
> DO WHILE length(record)>0
> parse var record var_name '=' remaining
> IF left(remaining,1)='('
> THEN DO
> parse var remaining data '),' record
> data=data')'
> END
> ELSE parse var remaining data ',' record
> 'OUTPUT' var_name'='data','
> END
>END
>error: exit RC*(RC^=12)
>
>
>Brian Nielsen
>
>
>
>On Tue, 28 Nov 2006 09:12:20 -0600, Huegel, Thomas <[EMAIL PROTECTED]>
>wrote:
>
>>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
>>
