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 - Show more from this author
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, 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, Melbourne
Nov 15, 2016
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, 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.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.