This would be from basic, but the idea is same. Problem is there could be a (@record="") record (just an @ID), I needed a way to differentiate between @record="" and Does not exist, which was why I used 'C', but this is complicated by there could be records that had only <1> that happened to be the same as the @ID, wherein lies the problem.
The double TRANS Bob mentioned should work, but is slower. George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Kate Stanton > Sent: Thursday, October 07, 2010 8:31 PM > To: U2 Users List > Subject: Re: [U2] Stumped with TRANS... > > How about: > > TRANS(filename,recID,@RECORD,'x'); IF @ = "" THEN 'not there' ELSE > @<1,fieldno> > > On Fri, Oct 8, 2010 at 12:21 PM, Bob Woodward > <[email protected]>wrote: > > > Can you chain two TRANS functions and compare the results? If you > use > > "C" the first time and "X" the second time then you would be able to > > know if there is no record when the two results are different. If > the > > record doesn't exist, you would only have @ID in the first result but > > the second result would be blank. If the record does exist and the > > field you are getting is the key value, then the first AND second > > results would be equal, both containing @ID. > > > > BobW > > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
