Brian Dunning's FileMaker Custom Functions

QualifiedEmailAddresses ( List of raw emailaddresses )

Filter emailadresses that comply to RFC5322 and added support for Diacritics in Latin characters plus Greek and Cyrillic characters

  Be the first to rate this function Log in to vote

Menno van Beek   Menno van Beek - Show more from this author
Van Beek Zakelijke Software
https://www.vbzs.nl

Share on Facebook Share on Twitter

  Sample input:
FilterValidEmailaddresses ( "someone@example.com¶a.person@mycompany..com¶über@paßau.de")
  Sample output:
someone@example.com
über@paßau.de

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

For one of my projects I was confronted with emailaddresses that contained diacritics like:
E.Paßau@München.de or reçus@comptabilité.fr
I needed a means to check these addresses and came up with this function. I added also support for Greek and Cyrillic, which can be switsched on/off by changing the value in the "include" parameter.
The function probably is easy to adapt to check Japanese and Chinese too, but I leave that to you.

This function will not process addresses like: <someone@example.com>. You will need to remove the < and > first. Only raw addresses will be properly validated. Also any toplevel name is accepted as long as it has 2 or more charachters

 

Comments

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 18 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: