CalculateInitials ( ~fullName )

Calculate the initials of a full name

Be the first to rate this function Log in to vote

Thomas DS - Show more from this author
kamalion
https://kamalion.io

Sample input:

CalculateInitials ( "Jean-Baptiste Grenouille" )

Sample output:

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

Let(
   [
      ~list = Substitute( ~fullName; " "; "¶" );
      ~max = ValueCount( ~list )
   ];
   While(
      [ i = 0; initials = "" ];
      i < ~max;
      [
         i = i + 1;
         initials = initials & Left( GetValue( ~list; i ); 1 )
      ];
      initials
   )

Parameter: ~fullName
Result type: text

Comments

		Fabrice Nordmann, 1-more-thing Jan 7, 2023
Hi, another version of this without recursion would be: Filter ( Proper ( ~fullName ) ; Upper ( ~fullName )) and if you would like to have only 1 initial for compound names (as in your example): Filter ( Proper ( Substitute ( ~fullName ; "-" ; "" ) ; Upper ( ~fullName ))

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

CalculateInitials ( ~fullName )

Comments

Support this website.

Support this website.