CODE EXAMPLE FOR PYTHON

python: if null give a value if not null concatenate

def concat_fields(field1, field2):
    if field1.strip() == "" or field2.strip() == "":
        return ""
    else:
        return field1 + field2