>Under very specific scenarios, something like this should work. But if >the string 'COMBO YS' exists more then once, it will only retrieve the >first value. And the syntax must be very consistent.
>1> I >2> INDEX(@RECORD< 999>,"COMBO YS","1");IF @1 > "0" THEN >@RECORD< 999>[EMAIL PROTECTED]"9","6"] ELSE "" Use the vector functions IFS() and INDEXS() instead, then you don't have to worry about how often it occurs. 001 I 002 ifs(indexs(NOTES,'COMBO YS',1),fields(NOTES,' ',3),'') ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ********************************************************************** ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/