Attribute Table not sorting text properly in text field?

298
3
04-11-2024 02:42 PM
CHNArcGIS
New Contributor II

I have a feature class in a geodatabase that is data type Text and contains text values, but when I right-click on the attribute table titles and choose to sort the table alphabetically by that column, the rows seem to come out wrong

Here is a screenshot below, the attribute "Type" is being sorted and this shows the values "Type 1" and "Type 2" are not in order.  What am I doing wrong that the sort doesn't go in order?

CHNArcGIS_0-1712871590088.png

 

0 Kudos
3 Replies
Eugene_Adkins
Occasional Contributor III

Check for spaces at the end of the entered text. It could be the culprit.

0 Kudos
DanPatterson
MVP Esteemed Contributor

coded domains?

BUG-000158191 for ArcGIS Pro (esri.com)


... sort of retired...
0 Kudos
Robert_LeClair
Esri Notable Contributor

I tested the sort ascending and descending on an attribute field that does not have a coded value domain on it and it sorts as expected.  Nulls first, Type 1 next and Type 2 lastly.  There is BUG-000158191 - "Sort ascending and descending on a field with missing coded value domains in the attribute table does not work."  It's reproducible in ArcGIS Pro 3.1.1 and 2.9.5 and is currently under review.  I would put values in the Null fields and test again.

0 Kudos