But if there is a field or value mark, the record is not empty. John Israel
Sent from my iPhone On Sep 1, 2012, at 12:35 AM, "Wjhonson" <wjhon...@aol.com> wrote: > If there is an attribute mark or value mark, they count as part of the Length > of the @Record. > So a record with only a single value mark, still has a length of 1. > > > > > > > > -----Original Message----- > From: Allen Elwood RR <aelw...@socal.rr.com> > To: U2 Users List <u2-users@listserver.u2ug.org> > Sent: Fri, Aug 31, 2012 8:29 pm > Subject: Re: [U2] Friday type of question > > > > does that still work if there are attr/value marks but everything else > is null ? > > not sure, never tried, but i know i've seen recs with nothing but these > before > > ellusian, lol, sounds like the aliens with the big brains that could > make you see things that weren't there in star trek (had to look it up, > it's talosians) > > On 8/31/2012 4:56 PM, Rutherford, Marc wrote: >> David, >> >> Create an 'I' type dictionary which with this function: >> >> < 1 > Top of "REC_LEN" >> >> 001: I >> 002: LEN( @RECORD ) >> 003: >> 004: LEN >> 005: 10R >> 006: S >> >> Select the file with your new dict = 0 >> >> SELECT PARTS WITH REC_LEN = "0" >> >> Marc Rutherford >> Principal Programmer Analyst >> Advanced Bionics LLC >> 661) 362 1754 >> >> -----Original Message----- >> From: u2-users-boun...@listserver.u2ug.org >> [mailto:u2-users-boun...@listserver.u2ug.org] > On Behalf Of Morelli, David W. >> Sent: Friday, August 31, 2012 4:43 PM >> To: U2 Users List >> Subject: [U2] Friday type of question >> >> Is there an easy way to determine if a record is empty? >> >> I have a saved list of a thousand or more records that have record ID's that > interfere with our Ellusian database. >> >> If they are truly empty, I can do house cleaning on them. If they contain >> any > data, I have to do a different process. >> >> When I AE into a record I get >> :AE PERSON 2362 >> Top of "2362" in "PERSON", 0 lines. >> >> So, it is really empty. >> >> I believe there must be a better way than handling every one of them, but I > have been away from Unidata and forgotten everything. >> >> David Morelli >> Pacific University >> Oregon >> >> _______________________________________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> _______________________________________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
