topic Re: Attribute table sorting issues in text fields in ArcGIS Pro Questions

Attribute table sorting issues in text fields

JoMoore__GISP — Thu, 26 Sep 2019 19:16:28 GMT

Attribute table sorting issues in text fields. ArcPro 2.4.1

The clip below shows a common attribute in two separate feature classes. The field structure and type are identical, there are no extraneous spaces. Both tables contain identical data in this field and are sorted in ascending order. The sort order of the dash "-" character is different. any ideas?

Re: Attribute table sorting issues in text fields

DanPatterson_Retired — Fri, 27 Sep 2019 00:07:07 GMT

are there differences in the locations of the featureclasses? (eg, local file gdb, SDE etc)

or their types?

['A5(md)4+10_5L', 'A5-1(md)25+99_9L']

is the correct order... as per python sorting

Re: Attribute table sorting issues in text fields

JoMoore__GISP — Fri, 27 Sep 2019 00:10:04 GMT

Yes the left table is an SDE in Portal, the right is a local GDB

Jo A. Moore, GISP

GIS Specialist

Bureau of Reclamation

Lahontan Basin Area Office

705 N. Plaza Street, LO-630

Carson City, NV 89701

tel: 775-884-8363

fax: 775-884-8376

email: jamoore@usbr.gov

“The greatest enemy of knowledge is not ignorance, it is the illusion of

knowledge.” ―Stephen Hawking

<http://www.goodreads.com/author/show/1401.Stephen_Hawking>

Re: Attribute table sorting issues in text fields

DanPatterson_Retired — Fri, 27 Sep 2019 00:24:33 GMT

No clue.... "(" comes before "-" in a sorted list of printable characters (determined using python 3.6.8, UTF-8 encoding... I can produce the examples if you want them)

Another one for SDE being itself I suppose

Re: Attribute table sorting issues in text fields

JoMoore__GISP — Fri, 27 Sep 2019 01:14:52 GMT

Thank You Dan,

Its been making my world a little crazy. I think my work around is to

create a separate sorting attribute.

Jo A. Moore, GISP

GIS Specialist

Re: Attribute table sorting issues in text fields

DanPatterson_Retired — Fri, 27 Sep 2019 03:27:23 GMT

BUG-000095569: Text fields are not sorted correctly in the Show Sel..

It is almost Friday, so I will look no more.

See if the Sort tool does the right thing, and move on from temporary sorting if that isn't the issue