Open clbarnes opened 3 years ago
I second this!
Looks like too many failures in MSExcel and Google Sheets? When quoted, which CATMAID's CSV file entries are, commas aren't an issue.
Tabs have the advantage that they aren't naturally used in names, and could even be actively replaced by a single space if present in any name to export.
The default unit separator character in all exports should be tab (well, it should be ascii 31 but it's a bit late for that). It plays nicer with unix tools, commas occur frequently in names and annotations, and field quoting is handled inconsistently by downstream tools.
New tabular exports should only handle TSV; I recommend moving existing exports from CSV to TSV.