from FMP v12 Help
Home > Using FileMaker Pro > Finding, sorting, and replacing data > Sorting records
• The longest text string that FileMaker Pro will sort is 100 characters.
Thanks, Malcom. That is the problem, in this case. Have to come up with something that generates a shorter path.
Instead of shortening the source data, you can break it into 100 character pieces and sort those.
If you have a field named LongText, then define two or more calculation fields that hold the first 100 characters, the second 100 characters, and so on until you reach the maximum length you need to sort.
First100Chars = Left(LongText; 100)
Second100Chars = Middle(LongText; 101; 100)
Third100Chars = Middle(LongText; 201; 100)
Use these calculated fields as sort keys in the sort dialog instead of using the original LongText field. First100Chars is the first field. Second100Chars is the second and so on.
Good idea. I'll test it.