<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - LibreOffice Calc FILEOPEN Import csv 'Format quoted field as text' does not work"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144842">bug 144842</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>erack@redhat.com
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - LibreOffice Calc FILEOPEN Import csv 'Format quoted field as text' does not work"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144842#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - LibreOffice Calc FILEOPEN Import csv 'Format quoted field as text' does not work"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144842">bug 144842</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>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] <a href="https://datatracker.ietf.org/doc/html/rfc4180">https://datatracker.ietf.org/doc/html/rfc4180</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>