I am having trouble in getting FM5.5 to count the individual words in a field for a number of records, ie:
If I have a field called colours and the first four records looked like this....
Red, Blue, Green, Grey
Purple, Green, Brown
Now if I use the "Index" function I get a list of all the individual words and I can get a field count for each record but what I need is how many times each word appears even separated by a comma.
Therefore, I would like to do is count each of the words that appear so that I get something that looks like this:
Any help would be greatly appreciated