Is there a code to auto populate a field with alphanumeric values in ascending order?

11-29-2018 08:59 AM
New Contributor

I have a field named FacilityID and it contains alphanumeric values that need to be populated in ascending order.  Our current work flow involves "X-ing out" the last four digits, then sorting the field in ascending order, and then finally going one by one and manually filling them in.  For example: 

FacilityID                                                        FacilityID

S-LL-L18-1002                                              S-LL-L18-1002

S-LL-L18-1003                                              S-LL-L18-1003

S-LL-L18-1004                                              S-LL-L18-1004

S-LL-L18-1005     ----------------------------->    S-LL-L18-1005

S-LL-L18-xxxx                                               S-LL-L18-1006

S-LL-L18-xxxx                                               S-LL-L18-1007

S-LL-L18-xxxx                                               S-LL-L18-1008

Is there a code that can auto populate the last four digits in ascending order? We would also need to specify which number the auto populate will begin at; in this case it would be starting at 1006 and then +1 after that. 

0 Kudos
1 Reply
MVP Esteemed Contributor

The attribute assistant as a method called Autonumber as well as GenerateID; not sure if deploying the AA would fit into your workflow or not....  

All methods - Attribute Assistant | ArcGIS Solutions 

Attribute Assistant | ArcGIS Solutions 

That should just about do it....