I am using the following pre-logic Python code to try to catch Null, empty, or "0" string values in the "street" column and then return a "V" value if it is one of those. While the code runs and works on some rows, it doesn't seem to be catching all empty cells. Am I missing a case? Or could it be that there are multiple spaces, and if so, how can I check for those?
def check(Street): if Street is None or Street == "" or Street == "0" or Street == None or not Street or Street == " ": return "V" else: return " "