LongestString ( text )

Returns the longest string of a given text and its length.

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

Daniele Raybaudi - Show more from this author
ACI
http://www.aci.it

Sample input:

LongestString ( "This is a really long text string that Jonathan needs to display narrowly in a huge text field." )

Sample output:

narrowly
8

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

/*
LongestString custom function

Author: Daniele Raybaudi

Returns the longest string of a given text and its length; if more than one string has the same length, it returns the last.
A string is definited as a space separated part of text.

I had to find a way to stop a bug of the good WordWrap CF by Jonathan Stark: it fails when the "size" parameter  is lower than the longest word of the given text.

*/

Let([
adj = TrimAll ( Substitute ( text ; ¶ ; " " ); 1 ; 1 ) & " " ;
adjLen = Length ( adj ) ;
positionFirstSpace = Position ( adj ; " " ; 1 ; 1 ) ;
string1 = Left ( adj ; positionFirstSpace - 1 ) ;
string1Len = Length ( string1 ) ;
positionSecondSpace = Position ( adj ; " " ; 1 ; 2 ) ;
string2 = If ( positionSecondSpace ; Trim ( Middle ( adj ; positionFirstSpace  +  1 ; positionSecondSpace - positionFirstSpace ) ) ; "" ) ;
string2Len = Length ( string2 ) ;
rest = Middle ( adj ; positionSecondSpace ; adjLen ) ;
nextText = Case ( string1Len > string2Len ; string1 & rest ; string2 & rest )
];
Case(
PatternCount ( adj ; " " ) > 1 ; LongestString ( nextText ) ;
Trim ( adj ) & ¶ & Length ( Trim ( adj ) )
)
)

LongestString custom function

Author: Daniele Raybaudi

Returns the longest string of a given text and its length; if more than one string has the same length, it returns the last.
A string is definited as a space separated part of text.

I had to find a way to stop a bug of the good WordWrap CF by Jonathan Stark: it fails when the "size" parameter is lower than the longest word of the given text.

Comments

		Greg Jun 19, 2014
Hello, I tried implementing on a current text field, but cannot get an sample output. I created a new text field as calculation, and set it to use the custom function. Do I need to pass any parameters to the function?

		Daniele Raybaudi, ACI Jun 20, 2014
You'll need to create a calculation field, result text. Also you'll need the Advanced version of Filemaker.

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

LongestString ( text )

Comments

Support this website.

Support this website.