Find records with certain number of words

Technical information that doesn't fall into any of the other categories in this forum.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
Kristen
Moderator
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Find records with certain number of words

Post by Kristen » Wed Dec 31, 2008 7:49 am

*To find records that only have a certain number of words in a field do the following*

1. Open the Search Editor (Under the Select Menu)
2. Select any field under “Fields”
3. Select the Custom Command Filter under “Conditions”
4. To find all records with 3-words in the Address field for example, enter this expression in Look For: WORDS(address)=3
5. Click Search

User avatar
Terry
Site Admin
Posts: 1983
Joined: Wed Sep 20, 2006 3:45 pm

Post by Terry » Mon Jan 05, 2009 1:46 pm

To further that a bit, you can also use <= or >= for "less than or equal", or "greater than or equal"...

WORDS(address)>=3

...would give you any records that have 3 or more words, as well.

Post Reply