Hi :)
WoooHooo!! Nicely done! :) Is this whole thread solved now? COngrats of so!
Regards from
Tom :)
From: Carl Paulsen carlpaul...@comcast.net
To: users@global.libreoffice.org
Sent: Thursday, 16 May 2013, 1:44
Subject: Re: [libreoffice-users] Case
Hi Tom.
Well, not quite. In my particular case this formula worked. But with
some off-list input from smarter brains than mine, I realize it wouldn't
work under many situations.
It turns out the formula would need to change a bit, otherwise what I
did would leave a trailing semi-colon
Just a quick question. What happens if any of the fields already contains a
semi-colon?
Iain
On Thursday 16 May 2013 10:23:23 Carl Paulsen wrote:
Hi Tom.
Well, not quite. In my particular case this formula worked. But with
some off-list input from smarter brains than mine, I realize it
Here's a formula that works. It's ugly, but it works.
=MID(SUBSTITUTE(SUBSTITUTE(;A1;B1;C1;D1;,;;,;),;;,;),2,LEN(SUBSTITUTE(SUBSTITUTE(;A1;B1;C1;D1;,;;,;),;;,;))-2)
The thing to do in a case like this is to break the problem down into
sections. There are many ways to approach this specific
That wouldn't change anything. The existing semi-colon would be treated
as just text in the field contents, so it would show up where it is in
the field as well as the formula one. If you already have semi-colons
in the fields at the end of the text, then they wouldn't be needed in my
case.