Word Count in Field

[Tony Martin]

HI everyone. I have a field which is user-controlled by radio buttons. I'm currently looking to create a calcumation field that tells me, out of all the possible text combinations, how many occurrences of the word "MINERS" are selected.

I've been on another 32 hr FileMaker bender and I'm brain dead. Any suggestions for how to make this happen?

[LaRetta]

If you use a global text field to hold the word you wish to find then it could be:

PatternCount ( text ; globalField )

If you want to only count complete words and eliminate false positives (if you want to find THE but not find THEM, then you begin and end with space, like:

PatternCount ( text ; " " & globalField & " " )

Edited June 11, 2009 by Guest