Bug #4636: Morpho should ignore commas inside double-quoted fields (CSV import) - Morpho - Ecoinformatics Redmine

Actions

Copy link

Bug #4636

closed

Morpho should ignore commas inside double-quoted fields (CSV import)

Added by Jim Regetz almost 15 years ago. Updated almost 14 years ago.

Status:

Resolved

Priority:

Normal

Assignee:

ben leinfelder

Category:

morpho - general

Target version:

1.9

Start date:

12/15/2009

Due date:

% Done:

Estimated time:

Bugzilla-Id:

4636

Description

It is a standard CSV convention to enclose fields containing commas (i.e., commas that do not represent delimiters) in double quotes. Most applications respect this convention. However, when importing or displaying a comma-separated data file, Morpho treats all commas as field separators regardless of double quotes. This means the automatic import wizard doesn't behave properly, and data are misaligned in the data panel viewer.

A workaround is to convert the CSV file to another format (e.g., tab-delimited) before importing, but this is not always convenient nor desirable.

Sample CSV file attached.

Files

comma_test.csv (37 Bytes) comma_test.csv

Jim Regetz, 12/15/2009 02:40 PM

Related issues

Actions

Copy link

Updated by ben leinfelder almost 14 years ago

Using opencsv library (had already used it in Metacat for a different project) to parse and write data files instead of the roll-your-own approach that was in place. This is on trunk in SVN.

Actions

Copy link