Use Global Text Field to Find Records
We have a list of email addresses that need to be searched for in one of our databases. Instead of going through one by one, I've heard there is a way to set up a global text field, put in a list of email addresses into it, and through some magic of scripting search through that field for all records with that contain one of those email addresses.
I am mostly confused on how to set this all up. I have a global text field, but not sure what exact sort of script is necessary to search through that field and compare it with another.
Would anyone have an idea of where to start? Bear in mind, I am just beginning to learn FileMaker and still learning all the appropriate terminology.