[Libreoffice-bugs] [Bug 132414] Allow multi-character delimiters in CSV import
https://bugs.documentfoundation.org/show_bug.cgi?id=132414 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |er...@redhat.com, |.freedesktop.org|heiko.tietze@documentfounda ||tion.org --- Comment #10 from Heiko Tietze --- You can escape characters that shouldn't be used as delimiter. Like "Foo;";"Bar";";";"Baz". Plenty of options and I would rather stick to the single character separator to keep things simple and familiar. Consider users complaining why ; doesn't work after unintentionally adding a space after, ie. "; ". => WF -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132414] Allow multi-character delimiters in CSV import
https://bugs.documentfoundation.org/show_bug.cgi?id=132414 --- Comment #11 from Eike Rathke --- 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132414] Allow multi-character delimiters in CSV import
https://bugs.documentfoundation.org/show_bug.cgi?id=132414 Justin L changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |WONTFIX --- Comment #12 from Justin L --- (In reply to Eike Rathke from comment #11) > pre-process the data before importing to make it comply with the syntax > of RFC 4180 (using any delimiter, not restricted to comma). Yes - exactly. LibreOffice does not need to cater to every conceivable textual data model. Anyone trying to manipulate text data should be able to search/replace with something like a | or whatever will work for their data set. > I'd rather not reimplement everything to allow a delimiter string instead of > a delimiter character.. WONTFIX -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132414] Allow multi-character delimiters in CSV import
https://bugs.documentfoundation.org/show_bug.cgi?id=132414 Buovjaga changed: What|Removed |Added Severity|normal |enhancement Summary|calc: csv: multiple |Allow multi-character |instances of columns|delimiters in CSV import |separator are treated as| |one | Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org --- Comment #9 from Buovjaga --- Indeed, discussed before: https://bugs.documentfoundation.org/show_bug.cgi?id=127718#c4 Stuart mentions that any Unicode glyphs can be used as separators. It does work with emojis, but you still need to merge the delimiters. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs