Filtered Word Count

[Tanner]

Hey everyone,

I have a text field that I use to keep a log of dates. Each date is seperated by a return and they are all in the same format. I have a need to get a count of these entries for a specified month. So my question is; is there any way to get a word count that is constrained by a certain value. For example, a word count on all words that start with 8. I am using filemaker 7 in a mixed platform setting. Thank you for any help.

[-Queue-]

PatternCount(

[Tanner]

Thank you, I think that is what I need. If I may ask one more thing, what if I wanted to narrow it down further to a specific year? If it helps my field looks something like this:

8/12/2004

8/20/2004

9/15/2004

9/24/2004

[-Queue-]

To append to the above, if you are using a global or variable field to enter the desired month, PatternCount(

[Tanner]

Thank you so much, everything works great!! I was wondering what the advantage of using the substitute command was? Is it required or does it just help simplify things?

-Tanner

[-Queue-]

What Substitute does is substitute "Y" for all occurences of "/" & year and "