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.

Under construction. Email me your wish list for improvements.