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 "" Good luck, Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pamela J Robbins Sent: Wednesday, June 28, 2006 12:01 PM To: [email protected] Subject: [U2] Question about a dictionary item Hi, I have a multi-value attribute that's made up of free text remarks. However, we put a couple of system messages there as well. I need to extract the 6 digit number that follows the "COMBO YS " in the line below, but I'm having trouble setting up the conversion code in the dictionary. Misc Text}Misc Text}COMBO YS 073102}Misc Text ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
