topic Attribute Table not sorting text properly in text field? in ArcGIS Pro Questions

Attribute Table not sorting text properly in text field?

CHNArcGIS — Thu, 11 Apr 2024 21:42:47 GMT

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?

Re: Attribute Table not sorting text properly in text field?

Eugene_Adkins — Thu, 11 Apr 2024 21:46:55 GMT

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

Re: Attribute Table not sorting text properly in text field?

DanPatterson — Fri, 12 Apr 2024 01:03:41 GMT

coded domains?

BUG-000158191 for ArcGIS Pro (esri.com)

Re: Attribute Table not sorting text properly in text field?

Robert_LeClair — Fri, 12 Apr 2024 20:59:58 GMT

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.