Script field calculation Python parser

Question

I am trying to use the field calculator to create an alphanumeric sequence, I tried to write a statement but I don't know what is wrong.

So my sequence would be in a field called "Field_number" in the attribute table with my desired sequential values in format (1A001, 1A002....1A999...1B001, 1B002...1B999...1C001). (Total record of 3215)The sequence numbers will range from 001 to 999, and the first two letters will follow the pattern 1A, 1B, 1C, and so on.

After creating my sequence in my Field_number Field, I then need to combine 2 attribute table together. But I am stuck on creating the Alphanumeric sequence field called "Field_number". Final look should be SPLCAR1A001....

Here's my code below: Pre-Logic Script Code:

rec = 0

letter = "A"

def autoIncrement():

    global rec, letter
    pStart = 1
    pEnd = 999
    pInterval = 1
    if rec < pEnd:
        rec += pInterval
    else:
        rec = pStart
        letter = chr(ord(letter) + 1)
    return "1{}{}".format(letter, str(rec).zfill(3))

And autoIncrement() TO generate

Answer 1

Using @Hornydd 's recommendation. You need to feed the "Creata" field into the script.

You script should read:

def autoIncrement(Creata):
    creata = Creata
    rec = 0
    letter = "A"
    pS = 1
    pE = 5
    pI = 1
    
    if rec < pE:
        rec += pI
    else:
        rec = pS
        letter = chr(ord(letter) + 1)
    return "{}1{}{}".format(creata,letter, str(rec).zfill(3))

Your initiator the "Field_Number =" part should bring in the "Creata" field should read:

autoIncrement(!Creata!)

Answer 2

Firstly you are calculating into the numeric field Field_number so you would never be able to create your code as that is text. You need to be calculating into a text field. Secondly you don't pass into your function the other field Creata to do the concatenation that you desire. Suggest you spend some quality time looking at the examples in the help file to understand syntax.

Answer 3

Figured it out. I didnt need my Creata and Field_number fields anymore. Thank You.

Here's the code Below.

rec = 0
letter = "A"

def autoIncrement():
      global rec, letter
      pStart = 1
      pEnd = 999
      pInterval = 1
      if rec < pEnd:
            rec += pInterval
      else:
rec = pStart
letter = chr(ord(letter) + 1)
    return "{}{}{}".format("SPLCAR1", letter, str(rec).zfill(3))

autoIncrement()