idea Change alpha-numeric sorting to match reality in Data Management Ideas

Change alpha-numeric sorting to match reality

ChrisRichardson — Thu, 01 Sep 2022 19:37:32 GMT

If I had numbers 1-10 in an attribute table and sorted by this field the number 10 would be placed between 1 and 2. Logically it should come after 9.
If I had the lower-case letters a-z, and upper-case A-Z in another field and sorted by that, the letters we be ordered as A,B,C...Z,a,b,c...z. In the real world 'a' comes before 'Z' regardless of case.

The same sorting is used in catalog, its ilogical there too.

My idea is that the sorting algorithm is reengineered to be more logical.

Re: Change alpha-numeric sorting to match reality - Status changed to: Already Offered

SSWoodward — Wed, 14 Sep 2022 17:39:26 GMT

Thanks for the idea!

In ArcGIS Pro, sorting attribute tables works just as you've suggested!

Sorting numbers will result in records arranged in logical numerical order. A record with value 10 is placed between 9 and 11, and not between 1 and 2.

Sorting records by a text field will arrange records in alphabetical order regardless of the capitalization of the entry in the sort field. 'a' and 'A' a no longer separated.

This idea will be closed as already offered. Thank you for the suggestion.