FileMaker Pro Custom Functions

Let ( [ fieldLen = Length (Trim (GetNthRecord (field; foundCnt))); foundCnt = If (foundCnt > 10000; 10000; foundCnt); // Standard recursion limit is 10K nextLen = If (foundCnt > 1; MaxLength (field; foundCnt - 1); 0) // If there's another record left, get its max length ]; If (fieldLen ≥ nextLen; fieldLen; nextLen ) ) /* ______________________________________________ FORMULA COMMENTS Function MaxLength ( field, foundCnt ) Purpose Determine the maximum trimmed character count for a field in current found set Parameters field = text field reference that will be checked foundCnt = typically the result of Get (FoundCount), but could be used to limit check to the first nth records Return 0 or the longest character length found. Notes Beware that is a recursive function, so a maximum of 10K records can be processed Created 2010-Jul-26 Author Simon Brown, Beezwax Datatools ______________________________________________ */
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.