Ron Pingilley's solution works, with his posted correction to plug in fields 5 and 9.
On 2/3/06, phil walker <[EMAIL PROTECTED]> wrote: > > Garry, > > Sorry to burst your bubble ;-). But I don't think he was looking for a > hardcoded answer. Your solution would work for the example he gave but I > am sure he wants a more generic solution which would 'locate' the value > of the 4th '*' delimited field in the FILE 1 @ID in field 5 of the FILE > 2 record and then return the value from the corresponding position in > field 9. > > Cheers, > > Phil > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Saturday, 4 February 2006 11:31 a.m. > 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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/