Do you have FileMaker Advanced? A recursive custom function that loops through the values of your list comes to mind.
A looping script that checks one value at a time is another option.
I do have advanced, but I'm still lost when making recursive custom functions.
This Custom Function : http://www.briandunning.com/cf/447
used in a calculation like this:
FilterValuesByTest ( YourList ; "value" ; "PatternCount ( value ; \"@gmail.com\" )" ; 0 )
will solve that problem.
If you'd prefer the looping script, let us know.
Thank you both!
Do you know of any good resources for understanding recursive functions?