Hello, I have a Python script which flags records with inappropriate values. Unfortunately, it is also flagging records without values. I would like to know how I can check for the existence of a value in a field. Normally, if there is a value in this field, it would be a string. Here's what I have currently:
if (suffval != '') and (suffval not in allowed):
the first condition is the one I'm having trouble with - the second condition seems to work fine.
By "records without values" do you mean records with NULL or records with just an empty string? If a string is empty it will have length zero.
I think this should do the trick: "if not allowed and not none and not an empty string" (well, maybe you don't have to worry about the None, so you can delete that perhaps)
if (suffval not in allowed) & (suffval is not None) & (len(suffval) != 0):
By "records without values" do you mean records with NULL or records with just an empty string? If a string is empty it will have length zero.
I assume the fields in question are NULL. I'm working with a street database, and this particular field is the directional suffix, which not every street requires.
When your suggested code didn't work, I prayed something else was wrong. Sure enough, instead of using NULLs or empty strings, my working database used a whitespace character. The following code produced the intended results:
