Help

How do I count phrases in a list?

Topic Labels: Formulas
Solved
Jump to Solution
809 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jo_Tarczynski
4 - Data Explorer
4 - Data Explorer

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.

Screen Shot 2022-05-19 at 10.51.07 AM
Screen Shot 2022-05-19 at 10.51.20 AM

1 Solution

Accepted Solutions
augmented
10 - Mercury
10 - Mercury

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.

See Solution in Thread

1 Reply 1
augmented
10 - Mercury
10 - Mercury

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.