You are here:

Filemaker/extracting email from enclosing letters


Hi Jamey, I hope this will be easy for you but I can't find the right text function to save my life.

When I copy emails from OS X Mail, they appear in this format:

john thorne <>.

I want to strip away everything through the < on the left and the > on the right to yield a pure email address. Obviously, the text preceding the one of the left will be of a different length each time depending on the name. So the < would be the key. ("Strip from left through >" would be the ideal way, but I can't find any text function that does this.

I thought I could figure out how to remove the > at the end, but the right text functions seem to want to remove everything but >. So I'm stuck there, too.

Since I process these emails several times a day, any light you can cast on this would be very gratefully received!  John


The function you are looking for (I believe) is going to be PatternCount.   You're going to have to familiarize yourself on how to use that because I dont know.  Ive seen it used before, but I really am not sure how it works.

Here is an example from a script step that someone wrote for me:

Case (

PatternCount ( ImportField ; "*ZZ*CSXINC" ) = 1 ; "CSX" ;
PatternCount ( ImportField ; "AH2RT" ) = 1 ; "UP" ;
"Error" )

So, it analyzes the Pattern and if its true, returns a 1.  So the bottom line is you will have to set up a script most likely to analyze the existing field using PatternCount.  If it returns a "1", it will require an action.......if it returns a "0" it will require another action.

Im also working on another angle on getting you a better answer.  Email me at and I will try to get you some help.



All Answers

Answers by Expert:

Ask Experts


Jamey Key


NEW and INTERMEDIATE USERS. WHAT CAN FILEMAKER PRO DO FOR ME? I have been using FileMaker products for over 10 years and have basic knowledge in all areas of FileMaker database set up and use. I`m not prepared to answer questions about complex situations or calculations but can help beginners and intermediate users set up and use FileMaker databases.


Have been using FileMaker since 1989 in our business. We have 10 users on the network who use these databases every day. Our largest databases have had over 30,000 records at one time. In 1995 one of my files was chosen as "Most Unique Database" in a contest sponsored by Claris, maker of FileMaker. Recently I have developed a set of files for new computer system installed at our church.

©2016 All rights reserved.