I have received a shapefile from a third party that contains a column of alphanumeric characters. ArcMap has it listed as a 'string' in the field properties. The numbers range from 1-6000 with a combination of letters after the numbers. So it looks like:
1 10 100 1000 1001
Then the list continues in a random order and it includes letters at the end such as:
I'm trying to find a way to sort this properly? Would I be best splitting it and then sorting and concatenating it again? Is there any easier way to sort this column?