Page 1 of 1

Find records with certain number of words

Posted: Wed Dec 31, 2008 7:49 am
by Kristen
*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

Posted: Mon Jan 05, 2009 1:46 pm
by Terry
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.