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.
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
section
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 i
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 wher
Hi :)
WoooHooo!! Nicely done! :) Is this whole thread solved now? COngrats of so!
Regards from
Tom :)
>
> From: Carl Paulsen
>To: users@global.libreoffice.org
>Sent: Thursday, 16 May 2013, 1:44
>Subject: Re: [libreoffice-users] "Case" function equivalen
