32

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)

enter image description here

50

Have you tried replacing the "=" with "is"? I don't have QGIS in front of me, but that is pretty common database select syntax for working with NULL values.

pedonal is NULL
0

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!

However

"ASSETID" = '', "ASSETID" IN ('') did work also for search "ASSETID" in ('2251', '4321' etc)

Archaic but workable.

-5

Try:

Pedonal = ''

  • that should work!
  • that works for text fields...i'm using numerical fields, and that selects values = to 0 – vascobnunes Oct 24 '11 at 15:48
  • 10
    @Darren Cope, NULL is different than "" – artwork21 Oct 25 '11 at 14:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.