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
|
|