Brian Dunning's FileMaker Custom Functions

Acronym ( text )

Returns the first letter of each word in phrase (in upper case).

  Average rating: 4.1 (53 votes) Log in to vote

Ray Cologon   Ray Cologon
NightWing Enterprises

Share on Facebook Share on Twitter

  Sample input:
Acronym("Your mileage may vary")
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Here is another recursive function which is designed to extract the initial letter of each word in the supplied text.

It may have a number of practical applications, including returning the initals from a name field or the acronym from a company name.

... or maybe you'd like to use it as the 'core technology' for a FileMaker guessing game that will keep your kids entertained some rainy day. :)



Dan Stein   Dan Stein, Bala Cynwyd
Nov 15, 2016
This is a bit shorter as a case statement

Case ( WordCount ( text ) > 0 ;

Upper ( Left ( text ; 1 ) ) & Acronym_CFpub ( RightWords ( text ; WordCount ( text ) - 1 ) ) ;

Ray Cologon   Ray Cologon, Melbourne
Nov 15, 2016
Hi Dan,

The change you're suggesting doesn't depend on the use of the Case( ) function. If you want to use they type of syntax you're envisioning, you'd be better off to go with:

Upper(Left(text; 1)) & Acronym(RightWords(text; WordCount(text) - 1));

Philip Rand   Philip Rand, Italy
Jul 8, 2018
Just to say I'm struggling with your function, but am grateful for the experience.
I still have to learn about Custom Functions.

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.