MaxLength ( field, foundCnt )

maximum trimmed character count for a field in current found set

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

Simon Brown
Beezwax Datatools
http://beezwax.net/

Sample input:

MaxLength ( tableName::fieldName; Get (FoundCount) )

If the field for the records in found set contained {"Sam", "Larry", "Dave"}

Sample output:

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

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

 ______________________________________________ */

Simple example of a recursive function for determining the maximum trimmed character length of a field for all records in found set.

My main use for this was to determine how large a space I needed to allocate on a layout for various fields.

Comments

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

MaxLength ( field, foundCnt )

Comments

Support this website.

Support this website.