topic Re: Catch blank/empty cells in attribute table (not <Null>) in Python Questions

Catch blank/empty cells in attribute table (not )

MKF62 — Fri, 10 Dec 2021 23:35:08 GMT

I have blank cells in an attribute table I'd like to catch using python. These cells are not filled with <Null> but are simply blank. Will this statement catch all possibilities in a blank cell? The blank cells could only occur in string fields and would be produced using Collector Classic on an iPhone since, for some reason, it doesn't enforce required fields like an Android phone does and instead just fills required text fields with an empty value.

if x == [None, '', ' ']:
    #do something‍‍

I think None actually catches <Null> but can't hurt to have it there I guess.

Re: Catch blank/empty cells in attribute table (not )

DanPatterson_Retired — Fri, 10 Dec 2021 23:35:11 GMT

None in [None, '', ' ']
True

'' in [None, '', ' ']
True

' ' in [None, '', ' ']
True

' ' in [None, '', 'b ']
False

' ' in [None, '', ' b']
False‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Catch blank/empty cells in attribute table (not )

DanPatterson_Retired — Fri, 18 Oct 2019 16:30:36 GMT

BTW <null> isn't a real thing it is a visual artifact used to represent None which is a real thing but isn't reflected by its textual representation... it is nothing and there is only one None