tomasd

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).

 

 

Outcomes