There are several conditions to search for, one of which is Null. The condition list is brought up by typing "??" at the prompt, for example: -B- SEARCH FOR EQUIPMENT INV. FIELD: nxrn # -B- CONDITION: ??
Choose from: 1 NULL 2 CONTAINS 3 MATCHES 4 LESS THAN 5 EQUALS 6 GREATER THAN YOU CAN NEGATE ANY OF THESE CONDITIONS BY PRECEDING THEM WITH "'" OR "-" SO THAT "'NULL'" MEANS "NOT NULL" Null is the first of the conditions in the list, and indicates an empty field. It can be selected by typing in "1", "N" or "NULL". So, using what you entered... -A- SEARCH FOR TIU DOCUMENT FIELD: enterED BY -A- CONDITION: NULL Good luck Paul Sherman, CCE Biomedical Engineer VHA Center for Engineering & Occupational Safety and Health (CEOSH) Voice: (314) 543-6712 Fax: (314) 543-6749 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Toppenberg Sent: Sunday, June 19, 2005 10:00 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] How to do a fileman search for EMPTY fields? Oops, I just tried it and it doesn't work. Here is a screen log Kevin Select FM VA Filename Option: search File Entries OUTPUT FROM WHAT FILE: TIU DOCUMENT// -A- SEARCH FOR TIU DOCUMENT FIELD: enterED BY -A- CONDITION: = EQUALS -A- EQUALS NEW PERSON: NULL ?? NEW PERSON: NUll ?? NEW PERSON: NULL ?? NEW PERSON: Press RETURN to continue... --- Gregory Woodhouse <[EMAIL PROTECTED]> wrote: > Just type NULL. > > === > Gregory Woodhouse > [EMAIL PROTECTED] > > Better. Faster. Cheaper. Pick two. > > > On Jun 19, 2005, at 7:03 PM, Kevin Toppenberg wrote: > > > I want to do a field for all records for which a particular field > > holds no data. > > > > Can I do this with a fileman search? If so, what would the syntax > > be? > > > > Thanks > > Kevin > > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies > from IBM. Find simple to follow Roadmaps, straightforward articles, > informative Webcasts and more! Get everything you need to get up to > speed, fast. > http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click > _______________________________________________ > Hardhats-members mailing list > Hardhats-members@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hardhats-members > ____________________________________________________ Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
