maxLength ( lst ; maximum )

Function that returns the length of the longest value in a list. Useful for conditional formatting

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

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

Sample input:

maxLength ("apple¶brocoli¶potato"; 0)

Sample output:

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

/*
Returns the maximum line length in a list or text.

Syntax :
   maxLength (line; maximum)

Returns :
   The number of characters in the longest line

Example :
   Set variable [$max; maxLength ("apple¶potato¶brocoli"; 0)]

Nicolas Bourré
*/
Let (
[
   line = GetValue (lst; 1);
   lstShort = RightValues (lst; ValueCount (lst) - 1);
   len = Length (line);
   maximum = If (len > maximum; len; maximum)
];
   If (ValueCount (lstShort) > 0;
       maxLength (lstShort; maximum);
   maximum)
)

Function that returns the length of the longest value in a list. This function could also be used to get the longest line in a text.

Could be useful for conditional formatting based on the longest line in a text field.

Comments

		KevinSmith Sep 12, 2018
The code is missing a bracket character. The first line of code should read "Let (".

		Nicolas BourrÃ© Sep 12, 2018
Corrected thanks!

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

maxLength ( lst ; maximum )

Comments

Support this website.

Support this website.