How to arrange number sequentially

828
3
04-27-2021 03:24 AM
alexandernongkhlaw
New Contributor

Hi everyone,

I just need help in one of my field...ive already input the numbers in my field but they are not coming serially even though i put them in ascending order instead of showing 1..2..3 etc the numbering shows as 1..100..102..2 etc can u help me so that the numbers come in ascending order..i hope u get my point..thank youNUMBERING.JPG

0 Kudos
3 Replies
DanPatterson
MVP Esteemed Contributor

It is called a "natural sort"

Migration from ArcMap to ArcGIS Pro for data validation—ArcGIS Pro | Documentation provides some coding options. 

In the future if you want to use "text" numbers, you can pre-pend 0's

0001

0011

0111

1111

If you don't want them be in text format, which they currently are, you will have to add a new integer field (short or long) and recalculate the values into it using

int(!YourFieldName!)

then use that field for sorting. 


... sort of retired...
alexandernongkhlaw
New Contributor

itried not working

0 Kudos
JoeBorgione
MVP Emeritus

What did you try that didn't work?

That should just about do it....
0 Kudos