[kmymoney] [Bug 463246] New: Importing CSV's with double-sets of quotes ("") splits the field

[bugzilla_noreply at kde.org]

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-devel at kde.org
          Reporter: matt at 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 the assignee for the bug.