Brian Dunning's FileMaker Custom Functions

ValidEmail ( theEmail )

returns valid email or null

  Average rating: 4.3 (30 votes) Log in to vote

Roger Biel   Roger Biel
2Geckos Consulting, LLC
www.2geckos.com

Share on Facebook Share on Twitter

  Sample input:
this is my email 2Geckos
  Sample output:
filemaker@2geckos.com

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

This script is very useful to extract a valid e-mail address from text.

 

Comments

Austin Burbridge   Austin Burbridge, Los Angeles
May 2, 2012
This wants the <stripReserved> function, which is not here!

Also, this validEmail is required by validURL, which is not mentioned in the validURL post
 
Roger Biel   Roger Biel, Casa Grande, Arizona
May 2, 2012
I've uploaded the stripReserved function, i thought i had already uploaded it.
 
Keawe Wong   Keawe Wong, Toronto
Jan 6, 2018
Awesome function! But the _ValidTopLevelDomains is many moons ago. Here is the more updated list:
https://data.iana.org/TLD/tlds-alpha-by-domain.txt

And here is the function to convert the list:

Substitute ( $$TLDs ; [" "; Quote(¶)]; ["\"" ; "" ])

// put the top lebel domain list in $$TLDs
 

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.

Under construction. Email me your wish list for improvements.