https://bugs.kde.org/show_bug.cgi?id=463246
--- Comment #8 from alx.ku...@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 watching all bug changes.
