Off the top, modify the I-Descriptor to be :
TRANS("OTHERFILE",NOTES,-1);@1[INDEX(@1,"COMBO YS ",1)+9,6]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pamela J
Robbins
Sent: June 29, 2006 09:54
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Question about a dictionary item (2nd question)
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 AnalystSchool 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/