[Libreoffice-bugs] [Bug 55049] FILEOPEN: CSV import - \" is not seen as an escaped quote, and hence interpreted as string delimiters

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=55049

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTOURBUG
             Status|NEW                         |RESOLVED

--- Comment #11 from Eike Rathke <erack at redhat.com> ---
This is not a bug.
The file content

"test";"\";\"";EOF

with field separator ';' and quote character (text delimiter) '"' is
*correctly* imported as

test|\|\""|EOF

The first \" is *not* an escaped double quote, CSV does not escape quotes by
backslash but by doubling them, it is a \ backslash enclosed in double quotes.

The third field with \"" is malformed because it contains a (meant to be
escaped by doubling it?) double quote but is not quoted with double quotes.
Calc tries to import it nevertheless and keeps all data encountered.

Whatever produced that content is a broken generator.

-- 
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/20210829/eb0c082b/attachment-0001.htm>