I have a fields that is populated with correct values, <Null>, and whitespace/empty. The field is of text value with both numbers and letters in the correct values. I want to remove all of the whitespace/empty and replace them with <Null> instead. I am trying to do this with the field calculator and python.
My current prelogic statement is:
if unitType == str():
And the box below is:
However when the field is calculated it turns all of the values to <Null> instead of just the whitespace/empty. Any Idea what I am doing wrong?