Find records with certain number of words
Posted: 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
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