Fifty don't hurt. My brother-in-law did it just yesterday! I had to buy a new shredder for all the AARP mailings, though.
:-) -- Dave Walker "The only reason some people get lost in thought is because it's unfamiliar territory." Paul Fix > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Friday, February 03, 2006 8:07 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UV I-descriptor > > > OK... so in a few months I'll be 50+ so I will be the OLD > 'FNG', with still > a lot to learn. > > I did keep Ron P's solution and I will try it out on some of > our files where > we have a G/L# in Field 2 and the dollar amount in Field 3. > > That's why I love this users group postings. Always some > great solutions. > > > > -----Original Message----- > > From: phil walker [SMTP:[EMAIL PROTECTED] > > Sent: Friday, February 03, 2006 3:03 PM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] UV I-descriptor > > > > 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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/