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
Solved! Go to Solution.
MyInput = " ooops "
def MrClean(MyInput):
if MyInput is not None:
return MyInput.strip()
print(MrClean(None))
None
print(MrClean(MyInput))
ooops
MyInput = " ooops "
def MrClean(MyInput):
if MyInput is not None:
return MyInput.strip()
print(MrClean(None))
None
print(MrClean(MyInput))
ooops
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.