[Libreoffice-bugs] [Bug 132414] Allow multi-character delimiters in CSV import

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #11 from Eike Rathke <erack at redhat.com> ---
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 comment #6)
> 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.

-- 
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/20200910/4ad0d7c2/attachment-0001.htm>