--- a/data/xls2csv.py +++ b/data/xls2csv.py @@ -11,10 +11,10 @@ def cleanseValue(column,value): if isinstance(value, basestring): - value = "".join([x if ord(x) < 128 else '' for x in value]) - value = value.replace('<','>').replace('>','<').replace('\n','
').replace('\r','
') + value = "".join([x if ord(x) < 128 else '' for x in value.replace(u"\u2022", u"\n•")]) + value = value.replace('<','>').replace('>','<').replace('\n','
').replace('\r','
').strip() else: - value = str(value) + value = str(value).strip() if column == 'ACNABN' and value != None: value = value.replace(' ','').replace(".0","").replace('"','').replace(",","") value = value.replace("ABN"," ").replace("ACN"," ").replace("/"," ").replace(":"," ")