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