Word count

[Jackmcc26]

Hi all, working on a dataset currently, I am wanting to find (within 1 column) which fields have 5 words or more within them. There are 1500 rows altogether. But yes i am wanting to find those with 5 words or more. How would i do this? 

[bensilv · Accepted solution]

Hi @Jackmcc26 , what you're looking for is a formula tool (followed by a filter) using the CountWords() function.

See the attached workflow

[Jackmcc26]

Appreciate the quick responses!