SurnameOnly ( text )
Extracts the surname from the tipical "Surname, Name" field.
Average rating: 4.6 (24 votes) Log in to vote
|
Javier Dura - Show more from this author
Afterdata http://www.afterdata.es |
Sample input:
SurnameOnly ( "Knight Smith, Michael" )
Sample output:
Knight Smith
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Sometimes you have to work with a field that contains names formated like this: "Surname, Name".
This super simple custom function extracts only the surnames (note that in some countries people have more than one surname).
See also the "NameOnly" Custom Function.
Comments
 |
Julian Garcia, Madrid Jan 9, 2013 |
|
| Muy útil, es una buena idea. Enhorabuena. Great, very usefull. Thanks Javier |
||
 |
Edward Jul 21, 2014 |
|
| Thanks for example to extract double Surname 'Knight Smith' How do I extract the first name from example: Surname, FirstName when the first name is double 'Mary Anne'? Knight Smith, Mary Anne |
||
|
Javier, Valencia, Spain Jul 21, 2014 |
|
| Hi, Edward. In order to extract the first name, you should use another custom function called "NameOnly": http://www.briandunning.com/cf/1496 |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.