Basic check for Null not working in ArcGIS Pro Field Calculator

NeoGeo — Fri, 19 Apr 2024 16:50:36 GMT

A super basic check for NULL in ArcGIS Pro Field calculator on a feature layer in ArcGISOnline does not work on a text field containing an address. It bombs and deletes all the data in the field or produces an error depending on which way I try to do it. It does not appear to equate None with NULL either.

Code:

MrClean(!ADDRESS!)

def MrClean(MyInput):
if MyInput is None:
pass
else:
return MyInput.strip

This is what I have tried:

if MyInput is None No error just wipes out everything in the field because it is not finding the NULL values
if MyInput == None No error just wipes out everything in the field because it is not finding the NULL values
if isnull(MyInput) NameError: name 'isnull' is not defined
if MyInput.isnull() AttributeError: 'str' object has no attribute 'isnull'
if isNull(MyInput) NameError: name 'isNull' is not defined
if MyInput is NULL NameError: name 'NULL' is not defined
if MyInput is Null NameError: name 'NULL' is not defined
if MyInput is null NameError: name 'NULL' is not defined
if MyInput == ' ' It wipes out everything and only gives this: WARNING 002858: Certain rows set to NULL due to error while evaluating python expression: File "<string>", line 9, in MrClean
if MyInput == null: NameError: name 'null' is not defined

Re: Basic check for Null not working in ArcGIS Pro Field Calculator

DanPatterson — Fri, 19 Apr 2024 17:03:07 GMT

MyInput = " ooops " def MrClean(MyInput): if MyInput is not None: return MyInput.strip() print(MrClean(None)) None print(MrClean(MyInput)) ooops

Re: Basic check for Null not working in ArcGIS Pro Field Calculator

NeoGeo — Fri, 19 Apr 2024 17:29:32 GMT

Thanks so much Dan! The problem was not the null at all. It was the syntax error I made where I left out the parenthesis but it did not generate an error.

topic Re: Basic check for Null not working in ArcGIS Pro Field Calculator in ArcGIS Pro Questions

Basic check for Null not working in ArcGIS Pro Field Calculator

Re: Basic check for Null not working in ArcGIS Pro Field Calculator

Re: Basic check for Null not working in ArcGIS Pro Field Calculator