A 15 second I-Descriptor :
NOTES[INDEX(NOTES,"COMBO YS ",1)+9,6]
If the length of the data you are after is variable to the end of the
field
NOTES[INDEX(NOTES,"COMBO YS ",1)+9,99]<1,1>
Or extends to the next space or end of field
NOTES[INDEX(NOTES,"COMBO YS ",1)+9,99]<1,1>[' ',1,1]
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pamela J
Robbins
Sent: June 28, 2006 15:01
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
Could someone give me some suggestions?
--
Pamela J Robbins New Bolton Center
Senior Programmer Analyst School of Veterinary Medicine
[EMAIL PROTECTED] University of Pennsylvania
610-925-6438
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
