[Libreoffice-bugs] [Bug 127718] Calc cannot split columns with multi-character delimiters

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Sep 23 19:04:54 UTC 2019


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

V Stuart Foote <vstuart.foote at utsa.edu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
                 CC|                            |vstuart.foote at utsa.edu
             Status|NEW                         |RESOLVED

--- Comment #4 from V Stuart Foote <vstuart.foote at utsa.edu> ---
No, using 'Other' with a multiple character separators is then collapsed using
the 'Merge delimiters' checkbox.

Caveat is that if you use or work with strings that actually contain the
separator character alone it would parse each out as additional columns.  But
any utf-8 Unicode codepoint can be used, not limited to ASCII so make a good
choice.

And unfortunately there is no awk/nawk style "string" separator; the Merge
delimiter does not act on the string--just each character of the string. 

But that would be an RFE

-- 
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/20190923/6971d007/attachment.html>


More information about the Libreoffice-bugs mailing list