https://bugs.kde.org/show_bug.cgi?id=463246
Bug ID: 463246
Summary: Importing CSV's with double-sets of quotes ("") splits
the field
Classification: Applications
Product: kmymoney
Version: 5.1.3
Platform: Other
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: importer
Assignee: kmymoney-de...@kde.org
Reporter: m...@eisgr.com
Target Milestone: ---
SUMMARY
I'm attempting to import Amazon Item Exports for reconciliation.
Amazon's Description column uses `""` to indicate a " symbol (since " is used
for surrounding a field). While LibreOffice handles this fine, KMyMoney treats
that as a field delimiter, even though I've specified that fields are delimited
by a comma (,).
This forces me to have to perform manual manipulation before importing, and is
against spec.
Thank you!
STEPS TO REPRODUCE
1. Create a CSV file with a line where the description field has a ""
(eg. "The thing we purchased measures 4""x6""." )
2. Import that CSV into KMyMoney
3. Look at the fields, and you'll see the "x6" and "." have their own fields.
OBSERVED RESULT
A few of my hundreds of lines parsed incorrectly, with "additional fields" that
don't exist in other transactions, because the " symbol is necessary for data
and the imported CSV uses "" to cause a " symbol to be part of the data.
EXPECTED RESULT
I expect the CSV to be parsed correctly, where fields are only separated by a
comma, if the comma is not within "-symbols, and "" causes a " symbol to be
part of the data.
SOFTWARE/OS VERSIONS
Windows:
macOS:
Linux/KDE Plasma:
(available in About System)
KDE Plasma Version:
KDE Frameworks Version:
Qt Version:
ADDITIONAL INFORMATION
--
You are receiving this mail because:
You are watching all bug changes.
