stringWithParams ( string ; paramList )

Function that substitute parameters in a string. The parameters are placeholders with a specific format. This function act some sort like the printf function in C.

Average rating: 4.3 (38 votes) Log in to vote

Nicolas BourrÃ© - Show more from this author
http://Www.nicolasbourre.com

Sample input:

stringWithParams ("My name is %3, I am %1 years old and I do love %2 for dinner."; "52¶potatoes¶John Smith")

Sample output:

My name is John Smith, I am 52 and I do love potatoes for dinner.

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

/*
Function that substitute parameters in a string.  The parameters are placeholders with a specific format.  This function act some sort like the printf function in C.

The format of a placeholder must be %X where X is the index number of the parameter in the list.

Syntax :
   stringWithParams (string; paramList)

Example :
   stringWithParams ("My name is %3, I am %1 years old and I do love %2 for dinner."; "52¶potatoes¶John Smith")


Nicolas Bourré
*/
Let (
[
   nbParams = ValueCount (paramList);
   placeHolder = "%" & nbParams;
   paramListShort = LeftValues (paramList; nbParams - 1);
   newString = Substitute (string; placeHolder; GetValue (paramList; nbParams))
];

   If (ValueCount (paramListShort) > 0;
      stringWithParams (newString; paramListShort);
   newString)
)

Function that substitute parameters in a string. The parameters are placeholders with a specific format. This function act some sort like the printf function in C.

The format of a placeholder must be %X where X is the index number of the parameter in the list.

Might be useful for multilingual solution.

Comments

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

stringWithParams ( string ; paramList )

Comments

Support this website.

Support this website.