• how do i account for columns that are "null"?

    There is not always a "streetsuffix", for example.