<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Allow multi-character delimiters in CSV import" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132414#c11">Comment # 11</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Allow multi-character delimiters in CSV import" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132414">bug 132414</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>Heiko, that does not address the original request that asks to be able to specify a sequence of characters like ';;' two semicolons to be treated as *one* separator, as the original data uses such field delimiter. It's nothing about quoting or escaping extraneous semicolons. The data probably is delimited such to cater for the case where one semicolon could be part of a field content and the generator software is too lazy to quote and escape field content. However, the Merge Delimiters option exactly solves this very problem except the case of a semicolon embedded in field content. If that is really needed then pre-process the data before importing to make it comply with the syntax of RFC 4180 (using any delimiter, not restricted to comma). I'd rather not reimplement everything to allow a delimiter string instead of a delimiter character.. (In reply to Mikhail Novosyolov from <a href="show_bug.cgi?id=132414#c6">comment #6</a>) > If I specify ';;' as A separator (a = > one), why does LibreOffice ignore the second ';'? In the Other input field one can specify a list of single character delimiters, not a string that is used as one delimiter.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>