Extracting email addresses from a text

[stevie.at]

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

[Ted S]

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.

[stevie.at]

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!

[Raybaudi]

Hi Stevie

even if you haven't a dev version of FileMaker, you can play with that custom function...

but you have to use this file to start from...

P.S. you can't edit or see that custom, but you can use it !

Double P.S.: to avoid problems with Italian version of FM vs American version, before to use this file, make an empty clone.

GetEmail.zip