Sorting with new line at the beginning

Discussion created by tomasd on Jun 6, 2016
Latest reply on May 2, 2017 by TSGal

Version: Filemaker 15, 11

OS: Windows 7,8


Text field with empty line at the beginning followed with some text is sorted wrong. Filemaker sort such field as empty.


Field: <new line>blabla

Right-click sort ascending


From help:

Numbers sort before letters. Non-alphanumeric values before the first word are ignored (unless you change the sort language to Unicode).