2 Replies Latest reply on May 6, 2014 6:46 PM by brodlang

    Character Limit for Sorting Fields



      Character Limit for Sorting Fields


           I have a calculated list ( ) field comprised of several fields from another table and which can be quite lengthy.  This field is included as a subsummary part of a report.  I am finding that the sort on this field isn't always accurate. Is there a limit to the number of characters FMP evaluates when sorting on a (calculated) text field? 

        • 1. Re: Character Limit for Sorting Fields

               There is approximately a 100 character limit if I recall a recent post by TSGal over in Report an Issue correctly, but maybe the fact that you have multiple values separated by returns is a factor. See what happens if you use substitute to replace the returns with spaces, and sort on that calculated value instead of the return separated list. Does that produce the results that you expected?

          • 2. Re: Character Limit for Sorting Fields

                 Thanks Phil. I added another similar field just for sorting. Used the substitue to remove the returns and spaces and it's working good now.

                 PS - I had the substitue syntax saved from a previous answer you gave me on Lists.