Brian Dunning's FileMaker Custom Functions

eParse ( text )

parse an e-mail addres from a string of text

  Average rating: 2.4 (203 votes) Log in to vote

David Schellenberg   David Schellenberg - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
eParse ( "my email is within this text,, please us it" )
  Sample output:

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

This is a simple function to get an e-mail address from a string of text. I have leveraged the MiddleValues functioin to put the address on its own carriage return line.



Marc Wood   Marc Wood, Minneapolis, MN USA
Jan 28, 2009
I used this to parse out a single date (instead of an e-mail) from a string of text. All I had to change was the at sign to a slash in the second position function, and change the test portion of the If function to the following: PatternCount (text ; "/" ) = 2.

Obviously, this only works if only one date is contained in the text and the date is in a certain format, but it worked for me.
Carl Riedel   Carl Riedel, Curator Contender
Dec 16, 2009
I tested this function and it works great if you have one email address in a text field, but I have a file with about 2000 eamil addresses in it. Any Ideas ?

Log in to post comments.


Note: these functions are not guaranteed or supported by 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 16 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: