address printer

address.py

import csv
import pprint

f = open('/tmp/test', 'r')
reader = csv.DictReader(f, dialect='excel-tab')
def mailTitle(t):
    if (t == 'Hon.'): return 'The Hon.'
    return t

def mailFormat(t, first, middle, last):
    return ' '.join( [x for x in [t, first, middle, last] if x != ''])

print '\t'.join(["Name", 'Address1', 'Address2', 'City', 'State/Region', 'Postal Code', 'Country'])

for r in reader:
    
    first = (r['First Name'] or "").strip()
    last = (r['Last Name'] or "").strip()
    middle = (r['Middle Name'] or "").strip()
    title = mailTitle((r['Title'] or "").strip())
    
    
    pfirst = (r['Partner First Name'] or "").strip()
    plast = (r['Partner Last Name'] or "").strip()
    pmiddle = (r['Partner Middle Name'] or "").strip()
    ptitle = mailTitle((r['Partner Title'] or "").strip())
    
    fullname = mailFormat(title, first, middle, last)
    if pfirst:
        fullname += ' and ' + mailFormat(ptitle, pfirst, pmiddle, plast)
    print '\t'.join([ x or '' for x in [fullname, r['Address1'], r['Address2'], r['City'], r['State/Region'], r['Postal Code'], r['Country']]])
    #pprint.pprint(r)