Bug #5257
closedIncorrectly rendered column data
0%
Description
Morpho doesn't seem to handle escaped quotes correctly in some CSV files.
In this example (from the attached CSV file):
"Fort Jefferson, FL",USA
"Kealakakua, HI",USAMorpho renders the the columns incorrectly (uses 3 columns rather than 2).
It may be a problem with the specific EML for this example, but it looks clean to me. The docid is pisco_smr_synthesis.1.3 and the data table is called "pisco_smr_studylist.csv".
This is running Morpho 1.9 on MacOS 10.6.
Files
| pisco_smr_synthesis.2.1-co_smr_synthesis.2.1.csv (21.9 KB) pisco_smr_synthesis.2.1-co_smr_synthesis.2.1.csv | |||
| screenshot.png (241 KB) screenshot.png | |||
| screenshot2.png (562 KB) screenshot2.png | |||
| Capture.PNG (113 KB) Capture.PNG |
Related issues
Updated by Darren Hardy over 13 years ago
Morpho 1.9 on Windows7 also renders the data table incorrectly.
Updated by Matt Jones over 13 years ago
This is probably just a shortcoming in our home-grown CSV parser. Since we developed this, effective CSV libraries have arisen for Java, and we could probably easily incorporate one of those. Might want to explore using, e.g., JavaCSV (http://sourceforge.net/projects/javacsv/).
Updated by ben leinfelder over 13 years ago
there is a bug for this already. I've looked into it briefly but it did not make it into the 1.9.0 release
Updated by ben leinfelder over 13 years ago
I checked that the data columns for pisco_smr_synthesis.1.3 were rendering with my new change- and they are