[Libreoffice-bugs] [Bug 97101] Add a SPLIT() function for separating string cells based on a delimiter

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Nov 4 21:33:51 UTC 2019


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

Wolfgang Jäger <jag at psilosoph.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jag at psilosoph.de

--- Comment #6 from Wolfgang Jäger <jag at psilosoph.de> ---
Starting with version 5.2.0 (2016-06-23) we have a TEXTJOIN() function, and
since 5.4 it is well debugged.  
3 and a half years later it is still crying for its counterpat function
TEXTSPLIT(). 

I would suggest to not only port the Basic function Split to Calc, but to do
something like (for simplicity in Basic-like notation):

Function TEXTSPLIT(pDelimiter, pMode, pList)
REM pMode should -at least- work like the second parameter of TEXTJOIN() does.
In Addition it may offer to suppress repetitions (pMode<0 e.g.)

A premium implementation would also accept array evaulation for ONEdimensional
(1 row / 1 column= pList arrays, probably corresponding with 1D pDelimiter
array with output to a 2Drange readable as a 1D array of columns or a 1D array
of Rows respectively. (I did it in Basic.)

-- 
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/20191104/8e4fdf02/attachment-0001.html>


More information about the Libreoffice-bugs mailing list