--- 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(":"," ")