I am trying to select a layer by attribute (field is null) using a stand alone python script.
#Select layer by attribute to find any null values arcpy.AddFieldDelimiters(mayIntLyr, "DEVICE_ID") select = '"DEVICE_ID" IS NULL' arcpy.SelectLayerByAttribute_management(mayIntLyr, "NEW_SELECTION", select)
It keeps returning error 000358, indicating the expression is invalid. Not sure what is wrong with my expression, and I tried adding field delimiters as well and it still doesn't work.
I am using ArcGIS 10.4, and have attempted to incorporate an answer from a similar thread to my code (shown below) to allow for null values, blank values, and spaces, but it still doesn't work.
select = "DEVICE_ID IS NULL and DEVICE_ID != '' and DEVICE_ID != ' '"