Extracting email addresses from a text

September 21, 200619 yr

I'm trying to find a good way to extract email addresses from a text and use this addresses to find records in other DB files and do some other automated stuff based on the found sets.

Problem is, an email adress can come along in a variety of ways, e.g. , or "[email protected]" etc...

So far I focused on the version including "<>" which happens to the addresses in the header in Entourage, if you forward it and then copy and paste the whole text into a FileMaker text field.

Question 1:

Is there a way (like PatternCount) to count all words that include "@" AND "<" to get the total number of valid emails in the text???

Question 2:

Is there a way to use the "@" and extract all letters to the left and right of it until you get to the next blank?

The coolest solution of course would be to extract all words inluding "@" and convert them into valid emails...

Any ideas???

Stefan

September 21, 200619 yr

Take a look at this:

http://www.briandunning.com/cf/326/

If it doesn't work for you then search for others on Mr. Dunning's site. There is a lot of handy stuff there.

September 22, 200619 yr

Author

Thanks!

Nice work...it's a good start for me but there's still the problem of getting rid of all this special character that might frame an address...(I don't have 8 advanced, so no GetEmail script step...)

But kind of what I was looking for!