Brian Dunning's FileMaker Custom Functions

ExtractingEmails ( TheText ; Separator )

Extract address eMail, what there is before and after the @ with the predefined separators. ( No to verify address )

  Average rating: 4.6 (27 votes) Log in to vote

Agnes Barouh   Agnes Barouh
Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html

Share on Facebook Share on Twitter

  Sample input:
ExtractingEmails ( "3 @ddress to extract
-------------

ExtractingEmails ( "*j.og@domain.com+address@mail.com*fr@com.net+@other*" ; "* + " )
  Sample output:
j.og@domain.com
address@mail.com
fr@com.net

-------------

j.og@domain.com
address@mail.com
fr@com.net

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

ExtractingEmails ( TheText ; Separator ) v1.1
//----------------------------------------------
to extract eM@ils
ExtractingEmails it is not a recursive function

-> No to verify address eMail, just extract what there is before and after the @ with the predefined separators.

//---------------------------------- Parameter

• TheText : Texte or List we contains eMail
• Separator : add your separator words, always separator followed by a space [sep][space][sep][space] etc
- by défault : # & ^ < \ > ¶ ( ! ) ; , : " " ”" “" ' ‘ ’ « » ? / ! [ ]
^
l_ "tab"

 

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.

Under construction. Email me your wish list for improvements.