From 67d1f62a4041451a431ebcef1859b60fb95862f7 Mon Sep 17 00:00:00 2001
From: Anders Einar Hilden <hildenae@gmail.com>
Date: Sun, 5 Jul 2015 21:10:17 +0200
Subject: Trim row values

---
 python/etatsbasen.py | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'python')

diff --git a/python/etatsbasen.py b/python/etatsbasen.py
index f56102a..6964cd0 100755
--- a/python/etatsbasen.py
+++ b/python/etatsbasen.py
@@ -90,6 +90,14 @@ def filter_column(row, headers):
             filtered_row[key] = row[key]
     return filtered_row
 
+def trim_row(row):
+    if row == None:
+        return None
+    trimmed_row = {}
+    for key in row:
+        trimmed_row[key] = row[key].strip()
+    return trimmed_row
+
 def printCSV(options):
     print(options)
     with open(options["inputfile"], newline='') as csvfile:
@@ -99,6 +107,7 @@ def printCSV(options):
             row = filter_orgstructid(row, options["categories"])
             row = filter_email(row)
             row = renameHeader(row)
+            row = trim_row(row)
             row = filter_column(row, options["headers"])
             if row != None:
                 filtered_rows.append(row)
-- 
cgit v1.2.3