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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Jürgen Kirsten <dscheikey at gmail.com> ---
I should like to support David's question.

I do not understand why it is not being implemented. In VBA the Split function
already exists. This should make it much easier.
I have written a small function that has helped me many times with this
problem.


Function SEP(text_chain, separator, chain_link)
' Function from Juergen Kirsten (mail: dscheikey at gmail.com)
' This function separates a text at the deffined separator and returns the nth
link.
' text_chain = String with separators
' separator = Sign ore signs in double quotation marks
' chain_link: The number of the chain link
On Error GoTo Errorhandler
i = UBound(Split(text_chain, separator)) + 1
If chain_link > i Then SEP = ""
SEP = Split(text_chain, separator)(chain_link-1)
Errorhandler:
End Function

Juergen

-- 
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/20200614/2ceddfef/attachment.htm>