Logical/Natural Sorting

Get help from the community here.

Moderator: Developers

grooff
Posts: 14
Joined: Sat May 07, 2016 2:54 pm

Logical/Natural Sorting

Postby grooff » Wed Jul 13, 2016 2:43 am

Currently Group Office sorting like so (classical alphanumerical sort):
1, 10, 11, 12, 13, 2, 20, 21, 22, 3, 30, 31.

It is possible to make it sort more logically? For example,
1,2,3,10,11,12,13,20,21,22,30,31

I have have to add "zero" infront of each value to get Natural/Logical sorting. For example;
01,02,03,10,12...20,21...30,31

But this issue will be a problem when I get to "100", so I have to go back and add another "zero" in front.
001,002,003,004...100

Thank you.

Return to “General help”

Who is online

Users browsing this forum: No registered users and 3 guests

cron