[Libreoffice-bugs] [Bug 144842] LibreOffice Calc FILEOPEN Import csv 'Format quoted field as text' does not work

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |erack at redhat.com
         Resolution|---                         |NOTABUG

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
Quoted field in CSV *starts* with a quote mark (normally "), and ends with this
mark. What you show is something that includes such a character in the middle,
and is *not* a quoted field.

Proper syntax of a quoted field:

123     "123    123"    123

If this sample is parsed with *tab* used as field separator, then it has three
fields, first 123, second "123   123" (starting with the quote, and going until
another quote followed by field separator), and third 123.

Another proper syntax:

"logdesc=""SSL VPN tunnel up""" "action=""tunnel-up"""

Here the first field would be "logdesc=""SSL VPN tunnel up""", where the middle
quotes are so-called "2DQUOTE" in the RFC, that would come as single literal
quotes in the result.

Incorrect syntax:

logdesc="SSL VPN tunnel up"     action="tunnel-up"

(which would still be read OK if you use tabs as separators, but would
*rightfully* fail your expectations if you use any space as a separator).

Ref.: RFC 4180.

Closing NOTABUG.

[1] https://datatracker.ietf.org/doc/html/rfc4180

-- 
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/20210930/4c8e874b/attachment.htm>