topic UpdateCursor help in Python Questions

UpdateCursor help

RyanPhillips2 — Wed, 23 Jan 2019 17:02:51 GMT

Hello,

I am having issues using the update cursor function. This is what I have written, I get no errors but it does nothing:

with arcpy.da.UpdateCursor("test1", ["SYM", "FLD_ZONE","Label", "ZONE_SUBTY"]) as rows:

... for row in rows:

... if row[3] == "" and row[1] in ["A", "AE", "AH", "AO", "VE"]:

... row[0] = 100

... row[2] = row[1]

... rows.updateRow(row)

basically if row[3] is empty and row[1] has these " " , update these rows with this

DanPatterson_Retired — Wed, 23 Jan 2019 17:13:49 GMT

if row[3] is None and row[1] in ["A", "AE", "AH", "AO", "VE"]:‍

assuming you don't have any spaces in row[3], in which case you would have to do another 'in' test for

ie row[3] in [" ", None]

RyanPhillips2 — Wed, 23 Jan 2019 21:10:02 GMT

Hello Dan,

Thank you so much for replying so quickly. The code works however it is still not populating anything into the fields.

DanPatterson_Retired — Wed, 23 Jan 2019 21:54:59 GMT

["A", "AE", "AH", "AO", "VE"]

are those the exact codes that are in there?

throw print statements in before the if statement to print out the contents of row[3] and row[1]