Brian Dunning's FileMaker Custom Functions

NameOnly ( text )

Extracts the name from the tipical "Surname, Name" field.

  Average rating: 4.8 (24 votes) Log in to vote

Javier Dura   Javier Dura
Afterdata
http://www.afterdata.es

Share on Facebook Share on Twitter

  Sample input:
NameOnly ( "Knight Smith, Michael" )
  Sample output:
Michael

  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 name.
See also the "SurnameOnly" Custom Function.

 

Comments

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.