Brian Dunning's FileMaker Custom Functions

ExtractEmails ( Text )

Extracts list of e-mails found in Text

  Average rating: 4.4 (32 votes) Log in to vote

Ilya Shuvalov   Ilya Shuvalov
SUI Solutions
http://filemaker.suisolutions.com

Share on Facebook Share on Twitter

  Sample input:
ExtractEmails("^john_smith@work.com; and some other email;marysmith@home.com? and one more please##bill.smith@hotmail.com,,,")
  Sample output:
john_smith@work.com
marysmith@home.com
bill.smith@hotmail.com

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Extracts from Text the list of all e-mails separated by carriage returns

 

Comments

Drew   Drew, Littleton, CO
Jul 15, 2009
This function did quite work as I expected it to. I passed text like this...

first1 last1 <account@domain>
first2 last2 <>

It returned the following...

<account@domain>
first2
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: