Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How do I count phrases in a list?

Topic Labels: Formulas
Solved
Jump to Solution
890 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.