My job is that I count a keyword in the file maker database.

I created a database file(a template), and I put some news articles in my database file

So, do you know(or let me know) How can I count a keyword(e.g.: "Food" "storage") and a group word(e.g.: "Food storage") in the filemaker software?

I really need to know the function (counting a word or a phrase)

I used the "Find" function

the function only shows me that how many news articles include "Food" keyword.

But, it can not show that how many times "Food" keyword include (or is counted) in each news article and whole news articles(a month or a year amount)

I made a script for counting

PatternCount("MainHeadline";"Food")

Once I run the script, the software doesn't work anymore

I have no idea what is going on

Thanks

Edited September 17, 200916 yr by Guest

If you want to be able to choose a word from a dropdown and show the count in the current article, or across all articles, the sample file will help with that.

Essentially, you need a text field (preferably global) to enter the word or word combo you are looking for, a calculation field with a PatternCount and a summary field that totals that PatternCount calculation field. This is all outlined in the attachment.

The z_wordsInText field and the WordsInAllText value list are not necessary except to run the dropdown on the word field that may be unneccessary for your purposes.

You can also enter word combos. Try typing team sport in the word box.

Is this what you were looking for?

WordCounter.fp7.zip

Edited September 17, 200916 yr by Guest