https://bugs.kde.org/show_bug.cgi?id=477294
Bug ID: 477294
Summary: Import from CSV fails when double-quoted text contains
commas and quotes are stripped
Classification: Applications
Product: LabPlot2
Version: 2.8.2
Platform: Ubuntu
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: frontend
Assignee: alexander.se...@web.de
Reporter: dreas.niel...@gmail.com
Target Milestone: ---
SUMMARY
***
Import from a CSV file to a spreadsheet produces mis-aligned columns when the
CSV file contains double-quoted text containing commas, and quotes are stripped
on import, and commas are also used as column delimiters.
It appears that double quotes are stripped *before* parsing each row into
columns, instead of *after*.
***
STEPS TO REPRODUCE
1. Create a CSV file containing double-quoted text columns where the text
includes a comma, and commas are also used as column delimiters.
2. Use File/Import to import that CSV file to a spreadsheet, using a custom
data format and checking the "Remove quotes" checkbox.
3.
OBSERVED RESULT
Tokens separated by commas within double-quoted text are put in separate
columns, pushing all subsequent columns to the right.
EXPECTED RESULT
Tokens separated by commas within double-quoted text should all be in the same
column.
SOFTWARE/OS VERSIONS
Linux/KDE Plasma:
(available in About System)
System: Pop!_OS_22.04 LTS
Installed from Ubuntu repository, pulling in all KDE dependencies
KDE Plasma Version:
KDE Frameworks Version: 5.92.0
Qt Version: 5.15.3
ADDITIONAL INFORMATION
--
You are receiving this mail because:
You are watching all bug changes.
