You poor address people... spaces sometimes 2, nulls, then concatenate... sometimes 3 fields, sometimes 6.
Notice I provided a LIST (ie there are square brackets around the fields... I just chose a random number of them
The code
def strip_space(in_flds):
""" provide the 6 fields to strip and concatenate
python parser"""
fixed = []
fmt = []
for i in in_flds:
if i not in (" ", None):
fixed.append(i)
fmt.append("{}")
frmt = " ".join([f for f in fmt])
frmt.strip()
flds = [str(i).strip() for i in fixed]
result = frmt.format(*fixed)
return result
and the cal attached