How do I identify which features have
NULL attributes in the attribute table of a shapefile?
When i try
[field]= 'NULL' it selects the features with
value = 0 (see picture)
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
I beat my brains about this one. The field name is "ASSETID", it is either a value or NULL. But actually the field was a text field (KML). I tried..
"ASSETID" ISNULL, "ASSETID" IS NULL, ISNULL("ASSETID"), "ASSETID" = "" NOTHING WORKED!
"ASSETID" = '', "ASSETID" IN ('') did work also for search "ASSETID" in ('2251', '4321' etc)
Archaic but workable.
This video instructs you how to update these selected Null values from another shapefile (layer). https://youtu.be/O2hkvJjR2_s