eParse ( text )
parse an e-mail addres from a string of text
Average rating: 2.4 (203 votes) Log in to vote
|David Schellenberg - Show more from this author|
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, 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, 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 ?|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.