EmailName ( account )
Returns the name associated with the email (sans domain)
Average rating: 4.0 (41 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This is a ruthlessly simple custom function that I made one evening to help myself out with a little example file I was working on. The example uses a script to pull emails that come from basics accounts such as firstname.lastname@example.org, email@example.com, firstname.lastname@example.org, email@example.com and firstname.lastname@example.org. I needed to extract the text in front of the “@” symbol to return accounting, sales, support, management and it (sans the @dwaynewright.com).
Since this example file is going to be moved into a number of files that I’m creating, I wanted to make it as portable as possible. So I went on a custom function hunt and didn’t find anything I needed. The needs are very basic. Look for the “@” symbol and get everything in front of it. The calculation is ...
Left ( address ; Position ( address ; "@" ; 1 ; 1 )-1)
Address is the name of the field that contains the the email address.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.