I would do it in a subroutine called from an I Type.
00001: I
00002: 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
X = INDEX(FIELDNAME<1,I>,'COMBO YS',1)
IF X THEN
ANS = FIELD(FIELDNAME<1,I>,' ',3)
RETURN
END
NEXT I
RETURN
This is just my way of doing it. HTH
Tom Dodds
[EMAIL PROTECTED]
513-563-2800 Cincinnati Office
708-234-9608 Chicago Office
630-235-2975 Anywhere Cell
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pamela J Robbins
Sent: Wednesday, June 28, 2006 3: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
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/
