--- a/data/xls2csv.py +++ b/data/xls2csv.py @@ -12,9 +12,9 @@ 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 = 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(":"," ")