How do I count phrases in a list?

Question

I am trying to count the number of key phrases in a list (text field). I found help on Split Text to Columns on how to count words, but am wondering if I can adapt the formula in such a way that counts phrases instead? Here are some screenshots! In the first image I would like record 1 to have a word count of 2 rather than 4. The second image shows the current word count formula.

Page 1 / 1

Hi Jo. The SUBSTITUTE should be changed to sub out the comma instead of white space.

IF(Words, LEN(Words) - LEN(SUBSTITUTE(Words, ',', ''))+1, 0)



I think that will do what you want.

Reply

augmented · Accepted Answer

Hi Jo. The SUBSTITUTE should be changed to sub out the comma instead of white space.IF(Words, LEN(Words) - LEN(SUBSTITUTE(Words, ',', ''))+1, 0)I think that will do what you want.

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded