If I want to reference this with a dictionary item in a second file, can I do that? I tried setting up an S type "NOTES" entry in the DICT item for the second file with the conversion set up as "T1,6}TFILENAME;X;44;44" and then tried using the code below for an I descriptor, but it couldn't handle it. The display was blank. Am I trying to do too much using the dictionary?

gerry-u2ug wrote:

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: u2-users@listserver.u2ug.org
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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to