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: [email protected] 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: [email protected] > 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 > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- 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/
