Submit | Open tickets | Closed tickets

[ Ticket #1211 ] Table canvas exports fields in double quotes
Date:
10/10/16 15:22
Submitted by:
B_Fristensky
Assigned to:
B_Fristensky
Category:
bioLegato
Priority:
5
Ticket group:
Bug
Resolution:
Resolved
Summary:
Table canvas exports fields in double quotes
Original submission:
The Table canvas exports tsv or csv files, enclosing all fields in double quotes. I consider this a bug. While it is true that some spreadsheets will do that, I don't think there is a need for it. The big problem is that the Table canvas does not know how to read fields enclosed in quotes.

Since there are already field separators to separate fields, it seems redundant, and unnecessarily complex, to also use quotes. Having said that, do the authors of spreadsheet programs to make it easier to identify things like numbers or formulas? Again, the protocol seems to be to preceed those with characters eg. = , so I'm not sure that we actually gain anything by quoting fields.

We should probably eliminate the quoting of fields.
Please log in to add comments and receive followups via email.
Followups
Comment Date By
Fixed in BioLegato 1.1.1.
Commented out lines that appended double quotes.
TSVFile.jj
CSVFile.jj
06/10/23 11:36 B_Fristensky
For the time being, the work around is to include a tr statement in the shell command to filter out all double quote characters. This is is not perfect, since there conceivably might be fields containing double quote characters.

This workaround has been implemented in blnfetch, blpfetch, blmarker and blncbi Extract functions.
10/10/16 15:24 B_Fristensky
No results for "Dependent on ticket"
No results for "Dependent on Task"
No other tickets are dependent on this ticket
Ticket change history
Field Old value Date By
status_id Pending 06/10/23 11:36 B_Fristensky
resolution_id Unset 06/10/23 11:36 B_Fristensky
close_date 12/31/69 19:00 06/10/23 11:36 B_Fristensky
assigned_to unset 06/20/19 13:30 B_Fristensky

© 1998-2025 Scilico, LLC. All rights reserved.