Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread Carl Paulsen
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.

Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread Dave Liesse
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

Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread mcmurchy1917-libreoffice
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

Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread Carl Paulsen
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

[Solved]?? Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread Tom Davies
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