yam2010

How to Increment a String ID

Discussion created by yam2010 on May 20, 2014
I'm using ArcMap 10.2 and I have an ID that is part Arcronym part part number.  I have created one script in the field calculator using Python to initially fill the field called FacilityID that I am populating as part of a Post Process.  What I need is a script for after the first run that will get the last three digits that are a number and use this to autopopulate Null FacilityID's.

Here is my original script.

    rec=0
    def autoIncrement():
     global rec
     pStart = 1 
     pInterval = 1
     if (rec == 0): 
      rec = pStart 
     else: 
      rec += pInterval 
     return "water" + "11" + "-" +  format(rec, '04d')   


Attribute Table :

[ATTACH=CONFIG]33941[/ATTACH]

Attachments

Outcomes