https://bugs.documentfoundation.org/show_bug.cgi?id=153055
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #1 from Mike Kaganski <mikekagan...@hotmail.com> ---
This is not a bug.
(In reply to eduardomozart182 from comment #0)
> I'd imported a CSV file to LibreOffice with the following line:
>
> "MSSQL 2017 - Qualitor - Usuário ""qualitor""","R
> Networks",Teampass,,qualitor,Qualitor!@#,"Usu?rio interno da inst?ncia
> \"MSSQLSERVER\" do MSSQL 2017 (server02), utilizado para conex?o da
> aplica??o Qualitor Web ao banco de dados do Qualitor. Para autentica??o ao
> banco de dados do Qualitor, ? necess?rio usar os usu?rios de dom?nio
> \"eduardo.mozart\", \"roberto.oliveira\" ou \"Administrator\"."
>
>
> Steps to Reproduce:
> 1. I opened it with LibreOffice only with the "Separated by" 'Comma'
> selected. It loads and shows up into the right columns as expected.
No, it doesn't load "as expected", because if you inspect it carefully, the
following piece goes into column H (i.e., into the next cell):
\"roberto.oliveira\" ou \"Administrator\"."
and the cell in column G ends with
\"eduardo.mozart\
And this is the correct behavior. If you look at the first field in the CSV, it
looks like
"MSSQL 2017 - Qualitor - Usuário ""qualitor"""
and appears in Calc as
MSSQL 2017 - Qualitor - Usuário "qualitor"
The quotations work as expected, according to the CSV specification RFC 4180
[1]:
> 7. If double-quotes are used to enclose fields, then a double-quote
> appearing inside a field must be escaped by preceding it with
> another double quote. For example:
>
> "aaa","b""bb","ccc"
Note: to escape the double-quote character, you use *another double-quote
character*!
Now look at the 7th field (as one *could* expect):
"Usu?rio interno da inst?ncia \"MSSQLSERVER\" do MSSQL 2017 (server02),
utilizado para conex?o da aplica??o Qualitor Web ao banco de dados do Qualitor.
Para autentica??o ao banco de dados do Qualitor, ? necess?rio usar os usu?rios
de dom?nio \"eduardo.mozart\", \"roberto.oliveira\" ou \"Administrator\"."
It starts and ends with a double-quote; and all internal double-quotes *must*
be escaped using another double-quote. But they are not. Instead, backslash is
used for that - which is wrong. And when parsing such a field, Calc finds an
*unescaped* double-quote, immediately followed by proper field delimiter
(comma), which happens after eduardo.mozart\; Calc correctly ends the field
here, and starts another field - which gets the rest.
And then, it outputs this to the file according to your specifications; the
field delimiter changes to semicolon, and it's used to separate 7th and 8th
fields.
[1] https://www.rfc-editor.org/rfc/rfc4180
--
You are receiving this mail because:
You are the assignee for the bug.
