add sitemap
[dcaas.git] / data / xls2csv.py
blob:a/data/xls2csv.py -> blob:b/data/xls2csv.py
--- 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('<','&gt;').replace('>','&lt;').replace('\n','<br/>').replace('\r','<br/>')
+		value = value.replace('<','&gt;').replace('>','&lt;').replace('\n','<br/>').replace('\r','<br/>').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(":"," ")