[kmymoney] [Bug 463246] 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

--- Comment #8 from alx.kuzza at gmail.com ---
(In reply to matt from comment #0)
> 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

Good news, it is reproducible :)
Could you, please, also provide the OS/Version you have a problem with.

-- 
You are receiving this mail because:
You are the assignee for the bug.