diff query_tabular.py @ 3:125fc5d123b3

Remove \r\n chars from input when loading db table
author Jim Johnson <jj@umn.edu>
date Wed, 04 Nov 2015 15:45:19 -0600
parents ffa5e34a55c1
children
line wrap: on
line diff
--- a/query_tabular.py	Sun Oct 04 10:52:21 2015 -0400
+++ b/query_tabular.py	Wed Nov 04 15:45:19 2015 -0600
@@ -94,7 +94,7 @@
           continue
         data_lines += 1
         try:
-          fields = line.split('\t')
+          fields = line.rstrip('\r\n').split('\t')
           vals = [col_func[i](x) if x else None for i,x in enumerate(fields)]
           c.execute(insert_stmt,vals)
         except Exception, e: