Increment fields with null values

Question

Hello,

I have a question about using python to auto increment numbers. I have a dataset with a range of numbers already defined (ID : 396548 - 410342) and (ID2 : 392988 - 406624). When I merged data I had fields that carried over 'Null' values. I do not want to change the known numbers, just the null values.

Here is a sample of my table, I have 27k fields with 13k numbered and the rest 'null'

IDID2nullnullnullnull396548392988410342406642

I'm using

rec=0

def autoIncrement():

global rec

pStart = 1  <BR /> pInterval = 1

if (rec == 0):

rec = pStart

else:

rec += pInterval

return rec

ID =

autoIncrement()

I've tried chaging 'rec' to the starting number (ID:396548), but it changes all numbers.

Am I using the right option or is there a better one out there

steveubert · Answer

I glossed over that little aspect. thanks for the help. I hate over thinking/looking simple things.

DanPatterson_Retired · Answer

field calculations apply to all OR just a selection in the table... did you try selecting the records/rows that you want to change, then do the field calculation?  You are also going to have to change 'rec' to be the first number that you want changed, otherwise, it will increment from 0