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}TFILENAM
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 ha
Thanks, the 15 second I-Descriptor worked perfectly for me in Universe.
Pam
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>
There could be other numbers within the attribute. I should have said
earlier, but we're running Universe.
Kevin King wrote:
Is there any other number in there? If not, why not simply use the
MCN conversion?
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
-Original Message
Hi Pam,
I am guessing you are on Unidata and probably a Datatel client, and if so,
many of the suggested methods won't work as they are designed for Universe.
The i-desc below should work for you. It returns your number 073102. More
over, it returns any number of numbers depending on how many "COM
>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
er will be "Y" not "COMBO YS
"
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of George Gallen
Sent: June 28, 2006 15:18
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Question about a dictionary item
FIELDS(ATTNAME,REUSE("YS "),2) or
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"] EL
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>
I would do it in a subroutine called from an I Type.
1: I
2: SUBR('GET.NUMBER',fieldname)
...
The subroutine could walk the values of the field and find the "COMBO YS"
and pick off the number.
SUBROUTINE GET.NUMBER(ANS,FIELDNAME)
ANS = ''
VM.CNT = DCOUNT(FIELDNAME,@VM)
FOR I = 1 TO VM.CNT
Is there any other number in there? If not, why not simply use the
MCN conversion?
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pamela J
Robbins
Sent: Wednesday, June 28, 2006 1:01 PM
To: u2-users
FIELDS(ATTNAME,REUSE("YS "),2) or is it FIELDS(REUSE("YS"),2,ATTNAME)
I forget which format is used in the DICT I desc. I haven't tested
this. I believe the REUSE needs to be there...
George
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of
> Pamela J
Hi Pamela,
Personally, I would setup a SUBR type dict and then just do a loop:
SUBROUTINE SUB.GET.NBR(RETURN.VALUE, DATA.ITEM)
C = DCOUNT(DATA.ITEM,@VM)
RETURN.VALUE = ""
FOR I = 1 TO C
IF DATA.ITEM<1,I>[1,8] = "COMBO YS" THEN
RETURN.VALUE = FIELD(DATA.ITEM<1,I>,' ',3)
RETURN
END
NEXT
13 matches
Mail list logo