You're so close, Gary, but the catch is setting the value "3" in the tail end of your FIELD function. The UOM will change from record to record in FILE1. That's what I need the LOCATE function for.
I do grant your elevation from newbie status, though. <smile> BobW -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV I-descriptor Finally a question I can answer. Oh boy I am not a newbie anymore. File1 dictionary item: Field(TRANS("FILE2",FIELD(@ID,'*',2),9,'X'),VM,3) so you TRANSLATE to FILE2 using the 2nd value in @ID to return the 9th element and then the 3rd position value. ***** Learning Universe for me as a newbie was challenging but the most difficult part of my job is trying to decipher the application design, since we are not provided with any technical documentation. Or our software vendor just does not have any good documentation and relies on a few "core" old timers to make changes and provide an oral history of the design. Questions like how is an AP Check disbursement tracked/indexed back to the Vendor Invoice go un-answered. So we have a TEST account where we reverse engineer the code. > -----Original Message----- > From: Bob Woodward [SMTP:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 12:19 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] UV I-descriptor > > Hi Peoples, > > I've got a question on coding an I-descriptor in a UV-Pick account. > > From file1 with a key of CO*PRODNO*WHS*UOM, I need to pull from file2 a > conversion value. File2's key is PRODNO with a multi-valued field of > UOM and an associated field of CONV.VAL. My problem comes in that > LOCATE is not valid in an I-DESC formula. > > I know I can make a basic program and call it but I prefer to have this > totally self contained within the DICT entry. Example data is: > > FILE1 @ID = "01*11223344*W1*EA" > > FILE2 @ID = "11223344" > <5> = "CS^SP^EA" > <9> = "1^2^12" > > I'm needing to get "12" back to the I-DESC in FILE1, again, hopefully > without having to resort to a called basic program. > > TIA > > BobW > ------- > 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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/