topic Re: How do I calculate a field using sequential numbers but maintain a defined number of digits? in Python Questions

How do I calculate a field using sequential numbers but maintain a defined number of digits?

JimNoble — Fri, 20 Dec 2019 13:55:40 GMT

I'd like to create a field of sequential numbers starting at 001 counting all the way until 322. Every number must be 3 digits. How do I do this?

Thank you all for your help.

Re: How do I calculate a field using sequential numbers but maintain a defined number of digits?

JakeSkinner — Sun, 12 Dec 2021 01:27:04 GMT

Hi James,

You can do this using the Field Calculator. Here is an example:

rec=0
def autoIncrement():
 global rec
 pStart = 1 #adjust start value, if req'd 
 pInterval = 1 #adjust interval value, if req'd
 if (rec == 0): 
  rec = pStart 
 else: 
  rec = rec + pInterval 
 if len(str(rec)) == 1:
     return "00" + str(rec)
 elif len(str(rec)) == 2:
     return "0" + str(rec)
 elif len(str(rec)) == 3:
     return str(rec)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How do I calculate a field using sequential numbers but maintain a defined number of digits?

JimNoble — Fri, 20 Dec 2019 21:20:29 GMT

Thanks Jake. That's perfect!

Re: How do I calculate a field using sequential numbers but maintain a defined number of digits?

JoshuaBixby — Sun, 12 Dec 2021 01:27:06 GMT

Another approach, instead of using global variables, is to use a generator:

Code Block:

def gen(x=0):
    while True:
        yield "{:0=3}".format(x)
        x+=1

g = gen()‍‍‍‍‍‍

Expression:

next(g)‍