topic Re: Sequential field calculation with Python in Python Questions

Sequential field calculation with Python

KatyW — Wed, 01 Jun 2016 14:35:07 GMT

I'm trying to field calculate some records that have a null value. I used the following code from the ESRI help section on sequential calculations. It worked! Now I need to modify the script a bit. This code gives me a sequential order of single digits. I would like to have some zeros before the new assigned digit. 0001 instead of just 1. How do I add the three zeros before the assigned digit? I would like a four digit value in the end. 0001, 0002, 0003, etc.

Thanks!

Here's the python code I used:

Parser:

Python

Expression:

autoIncrement()

Code Block:

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

return rec

Re: Sequential field calculation with Python

ChristianWells — Fri, 10 Dec 2021 20:01:57 GMT

Hi Katherine, you can return these values as strings with numbers prefixed by zeros using the zfill method.

Python String zfill() Method

num = 1
str(num).zfill(4)

'0001'

Re: Sequential field calculation with Python

KatyW — Wed, 01 Jun 2016 15:00:29 GMT

Where do I add this into my code? Or is this string code a separate process?

Re: Sequential field calculation with Python

KatyW — Wed, 01 Jun 2016 15:25:57 GMT

Here is the solution!

Use the original script to sequentially order. After that is done field calculate again using the field you wish to add the extra digits to. Then you can choose the string type as .zfill and add as many zeros as you would like. I attached a screen shot to help clarify. This gave me the result I was looking for!

Re: Sequential field calculation with Python

ChristianWells — Wed, 01 Jun 2016 15:47:02 GMT

Fantastic! Glad this worked out for you.