topic IF Statement and Update Cursor, Checking to see if text field is empty is not working in Python Questions

IF Statement and Update Cursor, Checking to see if text field is empty is not working

MichaelRivera — Thu, 21 Jul 2011 17:12:42 GMT

I'm using the following code:

cur=arcpy.UpdateCursor("parsolak.shp")

for row in cur:
    if row.PARCEL_NO == "":
        row.PARCEL_NO = "R-O-W"
        cur.updateRow(row)

del row,cur

I know the script is accessing the parsolak.shp shapefile because I see a lock on it. The mission is if any polygons have nothing in the PARCEL_NO field to populate the field with "R-O-W". When I reopen the shapefile, there are still 14,000+ records with nothing in the PARCEL_NO field.

Any help would be appreicated, thanks.

Re: IF Statement and Update Cursor, Checking to see if text field is empty is not wor

ChrisSnyder — Sat, 11 Dec 2021 16:11:01 GMT

How about:

cur=arcpy.UpdateCursor("parsolak.shp")
for row in cur:
   if row.PARCEL_NO in ("", " ", None): #covers blank, one blank space, or Null
      row.PARCEL_NO = "R-O-W"
   cur.updateRow(row)
del row,cur

The PARCEL_NO field is a text field, correct?

Re: IF Statement and Update Cursor, Checking to see if text field is empty is not wor

MichaelRivera — Thu, 21 Jul 2011 18:01:53 GMT

Yes PARCEL_NO is a string field.
Your script worked, much thanks 🙂