customize sort order logic(!)?
Posted: 25 Nov 2016 11:02
Hi all,
Is there a way how to customize the sort order logic?
Case:
Sorting by name I realized that the dot "." is sorted after the dash "-" which causes the side effect that a number with decimal places (using a dot for the decimal seperator) followed by a dash is sorted after the same base number followed by a dash directly. E.g. "document 11-2016.doc" would be sorted after "document 11.2-2016.doc". Using "Natural numeric sort order" in the config settings does not help.
If I could customize the sort order logic and define that the dot has to be sorted before the dash, it would help in this case.
(EDIT: Of course, I could try to make a CC and work with a complex RegEx and char-replace script and sort it then according to that column, but that is too cumbersome.)
Or else it would help to extend the "Natural numeric sort order" also to decimal numbers.
Any ideas if one of the two is aleady possible? (I could not find such.) Thx.
Is there a way how to customize the sort order logic?
Case:
Sorting by name I realized that the dot "." is sorted after the dash "-" which causes the side effect that a number with decimal places (using a dot for the decimal seperator) followed by a dash is sorted after the same base number followed by a dash directly. E.g. "document 11-2016.doc" would be sorted after "document 11.2-2016.doc". Using "Natural numeric sort order" in the config settings does not help.
If I could customize the sort order logic and define that the dot has to be sorted before the dash, it would help in this case.
(EDIT: Of course, I could try to make a CC and work with a complex RegEx and char-replace script and sort it then according to that column, but that is too cumbersome.)
Or else it would help to extend the "Natural numeric sort order" also to decimal numbers.
Any ideas if one of the two is aleady possible? (I could not find such.) Thx.