[Libreoffice-bugs] [Bug 118007] New: CSV-like files backslash escapes are imported technically correct, but unworkable - a "accept backslash as an escape" option would be nice.
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Tue Jun 5 09:31:40 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=118007
Bug ID: 118007
Summary: CSV-like files backslash escapes are imported
technically correct, but unworkable - a "accept
backslash as an escape" option would be nice.
Product: LibreOffice
Version: 4.3.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: eknagy at omikk.bme.hu
Description:
Some programs (e.g. MySQL) escape double quotes with backslashes, ignoring RFC
4180 2/7.
Libreoffice import is working technically correctly on these files, but the
result is "broken" for a layman who exports "CSV" and then imports "CSV".
An option to enable backslash-escaped double quotes (simply replace all
backslash+double quote with double quote+double quote?) would be verynice.
Steps to Reproduce:
Import this CSV-like file as CSV:
"test1","OK"
"test2","Kinda \" OK"
"test3","Problematic \""
"test4","behaviour"
Actual Results:
Three lines imported, line 3 has 3 fields.
Expected Results:
Four lines imported, all lines have 2 fields.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/67.0.3396.62 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180605/1f1d56ec/attachment.html>
More information about the Libreoffice-bugs
mailing list