Find records with certain number of words

Kristen · 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

Terry · 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.