AnsweredAssumed Answered

Common words in field

Question asked by flamingvan on Aug 10, 2017
Latest reply on Aug 14, 2017 by TomHays

Let's say I have a table named "answers" with a field named "answerText", and I collect survey data in this field.  To analyze the data, I want to display a list of the 10 most common words used in the text in this field.  For example I want a list like:


dissatisfied       -- 1023

happy               -- 826

recommended  --721



I already built a solution, but I had to make a related table named "words".  Every time an answer record is created, a group of "word" records are created, one for each word in the answer.  Then I can just group (or subsummary) by word in a report.


But I'm wondering if there's a better way?