How to Delete NULL Records

[H_A_D_Padmasiri]

Dear Sir

I want to update "CNT_PT_ID" field & delete the NULL records ("CNT_PT_ID" is NULL). I wrote a python script.When it runs "CNT_PT_ID" is update correctly. But "CNT_PT_ID" = "Null" records not deleted. No error message display. Can you give me a help to correct it.

Thanks


Padmasiri

[WilliamCraft]

Try changing CNT_PT_ID" = "Null" to be "CNT_PT_ID" IS NULL instead.  Does that work?

[H_A_D_Padmasiri]

Try changing CNT_PT_ID" = "Null" to be "CNT_PT_ID" IS NULL instead.  Does that work?

No it does not work it gives following error
Traceback (most recent call last):
  File "J:\Gampaha\Scripts\Script1.py", line 109, in <module>
    if row.CNT_PT_ID is NULL:
NameError: name 'NULL' is not defined

Failed to execute (LISTool1.0).

Thanks

[benberman]

It should look something like this:

cur = arcpy.UpdateCursor("CNT_Anno")
for row in cur:
        val1 = row.getValue("Some attribute field")
        if val1.isdigit():
                if int(val1) >= 9000:
                        row.setValue("CNT_PT_ID", int(val1))
                        cur.updateRow(row)
        if row.isNull("CNT_PT_ID")==True:
                cur.deleteRow(row)
del cur
del row

you may also be able to get away with deleting the isdigit() line.

[Zeke]

Python also often uses None instead of Null.

[MathewCoyle]

Give this a try.

layer = r'CNT_Anno'
cur = arcpy.da.UpdateCursor(layer, ['TextString', 'CNT_PT_ID'])
for row in cur:
    if row[0]:
        try:
            if int(row[0]) >= 9000:
                row[1] = int(row[0])
                cur.updateRow(row)
        except:
            pass
    if row[1] is None:
        cur.deleteRow()

[H_A_D_Padmasiri]

It should look something like this:

cur = arcpy.UpdateCursor("CNT_Anno")
for row in cur:
        val1 = row.getValue("Some attribute field")
        if val1.isdigit():
                if int(val1) >= 9000:
                        row.setValue("CNT_PT_ID", int(val1))
                        cur.updateRow(row)
        if row.isNull("CNT_PT_ID")==True:
                cur.deleteRow(row)
del cur
del row

you may also be able to get away with deleting the isdigit() line.

 
Dear FLBB

It gives me Following Error

Traceback (most recent call last):
  File "J:\Gampaha\Scripts\Script1.py", line 109, in <module>
    if row.isNULL("CNT_PT_ID")==True:
  File "c:\program files\arcgis\desktop10.1\arcpy\arcpy\arcobjects\_base.py", line 28, in __getattr__
    raise AttributeError("%s" % attr)
AttributeError: isNULL

Failed to execute (LISTool1.0).
Thanks

[benberman]

Dear FLBB

It gives me Following Error

Traceback (most recent call last):
  File "J:\Gampaha\Scripts\Script1.py", line 109, in <module>
    if row.isNULL("CNT_PT_ID")==True:
  File "c:\program files\arcgis\desktop10.1\arcpy\arcpy\arcobjects\_base.py", line 28, in __getattr__
    raise AttributeError("%s" % attr)
AttributeError: isNULL

Failed to execute (LISTool1.0).
Thanks

You typed "isNULL". You need to be typing "isNull". Case sensitivity very important in python.

[AhmedEl-Sisi]

This approach should work for you

if not row.CNT_PT_ID :
        cur.deleteRow(row)