def fulladdress(num, prefix, street, sttype, suffix, unit): # Concatenate fields # for addresses without unit if unit: fulladd = num +' '+ prefix+' '+street+' '+sttype+' '+suffix+' #'+unit # for addresses with unit else: fulladd = num +' '+ prefix+' '+street+' '+sttype+' '+suffix # Remove unwanted spaces fulladd = fulladd.strip() fulladd = fulladd.replace(' ',' ') return fulladd
def fulladdress(num, prefix, street, sttype, suffix, unit): if unit not in [None, '']: fulladd = num +' '+ prefix+' '+street+' '+sttype+' '+suffix+' #'+unit else: fulladd = num +' '+ prefix+' '+street+' '+sttype+' '+suffix fulladd = fulladd.strip() fulladd = fulladd.replace(' ',' ') return fulladd
In your database, what is the field value when there is "no unit field value"?
Is it Null, '', ' ', or ?
if len(unit) < 1:
what if you tryif len(unit) < 1:
def fulladd(num, prefix, street, sttype, suffix, unit): fulladd = (num + ' ' + prefix).strip() fulladd = (fulladd + ' ' + street).strip() fulladd = (fulladd + ' ' + sttype).strip() fulladd = (fulladd + ' ' + suffix).strip() if unit.strip() not in ['None','',' ']: fulladd = fulladd + ' #' + unit return fulladd
def fulladd(num, prefix, street, sttype, suffix, unit): fulladd = '' for add in [num,prefix,street,sttype,suffix]: fulladd = ''.join([fulladd,' ',add.strip()]).strip() if unit.strip() not in ['None','']: fulladd = ''.join([fulladd,' #',unit.strip()]) return fulladd
def fulladd(num, prefix, street, sttype, suffix, unit): add = [num,prefix,street,sttype,suffix,''.join(["#",unit.strip()])] fulladd = [''.join([a.strip()," "]) for a in add if a.strip() not in ['#None','','#']] fulladd = ''.join([f for f in fulladd]).strip() return fulladd