diff vsnp_build_tables.py @ 1:b60858c3eb91 draft

Uploaded

--- a/vsnp_build_tables.py	Tue Apr 21 10:00:22 2020 -0400
+++ b/vsnp_build_tables.py	Thu Apr 30 15:31:55 2020 -0400
@@ -15,9 +15,10 @@
 # Maximum columns allowed in a LibreOffice
 # spreadsheet is 1024.  Excel allows for
 # 16,384 columns, but we'll set the lower
-# number as the maximum since Galaxy is
-# mostly run on Linux.
-MAXCOLS = 10000
+# number as the maximum.  Some browsers
+# (e.g., Firefox on Linux) are configured
+# to use LibreOffice for Excel spreadsheets.
+MAXCOLS = 1024
 OUTPUT_EXCEL_DIR = 'output_excel_dir'
 
 
@@ -245,7 +246,7 @@
             for line in fh:
                 line = re.sub('[:,]', '\n', line)
                 line = re.sub('[)(]', '', line)
-                line = re.sub('[0-9].*\.[0-9].*\n', '', line)
+                line = re.sub(r'[0-9].*\.[0-9].*\n', '', line)
                 line = re.sub('root\n', '', line)
         sample_order = line.split('\n')
         sample_order = list([_f for _f in sample_order if _f])