Attribute table sorting issues in text fields

[JoMoore__GISP]

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?

[DanPatterson_Retired]

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

[JoMoore__GISP]

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>

[DanPatterson_Retired]

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

[JoMoore__GISP]

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

[DanPatterson_Retired]

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