Need to purge emails in FM7 from a csv file

[Brother Joe]

I have a csv file of several hundred bad email addresses which I want to purge from my database, but I can't figure out how to create a script which draws on a file outside of the database. Any help is greatly appreciated.

Thanks!

[Fenton]

Open the .csv file with FileMaker, to get a FileMaker file. Create a relationship from the email field to the email field in your main database, I'll call it "emails_email"

We'll call the field(s), "email_address" (for clarity).

Simple method:

In your "bad emails" file.

View as Form

Show All Records

Go To Record/Request [ First ]

Loop

emailsbad.zip