Thanks Bryan, Glenn, Ian and others.
I had since come up with the same conclusion using the following which seems
to work well:
SUBR("-IFS",KEYTWO NE "",SUBR("-CATS",REUSE(@ID:"*"),KEYTWO),"")
It may be an over kill, but it does the job. After I sent off the help
request, I had tried a few things with REUSE() that didn't work well until I
used -CATS also (duh!).
Oh well, it's nice to have such a great resource available like the members
at u2-users.
Again, thanks to all who have helped. Receiving the list via digest mode it
hard to see replies right away.
Paul
------------------------------
Date: Tue, 21 Sep 2004 14:25:53 -0400
From: Glenn Herbert <[EMAIL PROTECTED]>
Subject: Re: [U2] [UD] - I-Desc IF, THEN, ELSE or SUBR -IFS
Field 2 should be:
CATS(REUSE(@ID),CATS(REUSE("*"),FILETWO))
Try
SUBR("-CATS",REUSE(@ID:"*"),KEYTWO)
Since the ID is not multivalued, you have to provide a hint to say you want
to repeat it for each multivalue.
Hth,
Ian
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
