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

d.schellenberg   d.schellenberg
rivet design communications
http://www.rivetcom.ca

Share on Facebook Share on Twitter

  Sample input:
eParse ( "my email is within this text, filemaker@rivetcom.ca, please us it" )
  Sample output:
filemaker@rivetcom.ca

  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.

 

Comments

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, Croydon, UK
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 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 15 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:

Under construction. Email me your wish list for improvements.