# HG changeset patch
# User Jim Johnson <jj@umn.edu>
# Date 1446673519 21600
# Node ID 125fc5d123b3d18a98fde7f8ce1c8553b66ab25a
# Parent  ffa5e34a55c1013aceb6b04428fbc70795c0a28a
Remove \r\n chars from input when loading db table

diff -r ffa5e34a55c1 -r 125fc5d123b3 query_tabular.py
--- 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: