Spam log into Filemaker

[AudioFreak]

Hi guys,

We have a spam catcher program running at work which allows us to filter out unwated emails. Company receives about 300 to 400 spams daily. The log file has to be checked to make sure that no good emails were blocked. We know what filters are the most likely to block a good email.

I would like to be able to get the file into Filemaker to be able to search for the filters that are most likely to block a good email.

The log looks like this:

---

From:Ferrara Brain Pan

To:Stan Reed , Thomas Dohmen , Ure Thra

Subject:[Drone] Drone Zone

Date:February 12, 2004, 20:10:52

Deleted on: February 12, 2004, 20:36:41 from

Filter:drone

---

---

From:[email protected]

To:[email protected]

Subject:hi

Date:February 12, 2004, 21:52:26

Deleted on: February 12, 2004, 21:52:36 from

Filter:Novarg Subject

---

I tried coverting the file into Filemaker but that treats each line as a record. I know a way I can parse the info into fields but, how can I get Filemaker to create a new record when needed(The parsing will have to take place 300 to 400 times.

Maybe the text file could be converted to another type of file before the import into Filemaker. Or is there a way to clean up the text file itself before import?

I'm going to keep trying at this. Hopefully someone here will have a suggestion.

Thanks, Michael

Version: v6.x

Platform: Windows XP

[AudioFreak]

Just wanted to let everyone know that Lee Smith walked me through this process using BBEdit. The process is not too bad once you understand what is going on during the clean up.

Thanks Lee