<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Add a SPLIT() function for separating string cells based on a delimiter"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=97101#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Add a SPLIT() function for separating string cells based on a delimiter"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=97101">bug 97101</a>
from <span class="vcard"><a class="email" href="mailto:dscheikey@gmail.com" title="Jürgen Kirsten <dscheikey@gmail.com>"> <span class="fn">Jürgen Kirsten</span></a>
</span></b>
<pre>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: <a href="mailto:dscheikey@gmail.com">dscheikey@gmail.com</a>)
' 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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>