Search for blank/empty and NULL records

2Quiker

I am trying to print empty/blank or Null records with the following but when nothing is printed and there is empty/blank and Null records in the layer. I would also like to print the number of empty/blank or Null records.

 

 

 

fc = "C:/Temp/Test.gdb/feature Class"

fields = ["OBJECTID", "PN1"]

for field in fields:
    where = field + " IS " " OR NULL"
    try:      
        with arcpy.da.SearchCursor(fc, fields, where) as cursor:
            for row in cursor:
                print("OBJECTID {0}").format(row[0]) +  " has a Empty/ Blank or NULL value in field " + field
    except RuntimeError:
        pass

del cursor

counter = 0
with arcpy.da.SearchCursor(fc,["OBJECTID","PN1"]) as cursor:
    for row in cursor:
        if row[1] in ["", " ", None]:
            counter += 1
            print('{}  {} is null {} times'.format(row[0],row[1],counter))
        else:
            pass

 

 

 

Brian_Wilson

Without testing it right this minute it looks like you have something like this

field IS " " OR NULL

and I think that might evaluate as

(field IS " ") OR (NULL)

which means nothing to me. You would need to write it as

field = " " OR field IS NULL

Then the problem becomes that the first part only matches if the string contains exactly one space. You probably want an empty string,

field = "" OR field IS NULL

I have actually had datasets that had fields with one space in them, those can drive you crazy. You could probably find a neat SQL way to strip extra spaces and then check the length of the result string but I don't know how to do that in SQL. In python for example this gives 0 as the return: len("      ".strip())

Personally I have taken to using pandas for things like this, it does the hard parts internally where I don't see them and does them 10x as fast. It's another learning curve though. Later for that maybe.