Select to view content in your preferred language

How to arrange number sequentially

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

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 II

itried not working

0 Kudos
JoeBorgione
MVP Emeritus

What did you try that didn't work?

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