Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


All I've ever been aware of is nested IF statements, which get to be a royal pain. If there is a CASE equivalent (it's also present in just about any programming language), I'll be just as happy as you!
Dave



On 5/15/2013 13:16, Carl Paulsen wrote:
Anyone know if there is an equivalent to the Filemaker Pro "Case" function? It's kinda like the "IF" function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is, then do that, if the next thing is true, do that, etc.
Here's what I need to do.  Take 4 columns and concatenate with a 
semi-colon between the values, but not string together two semi-colons 
consecutively.  Like:
Phone     Email     Mail -> Phone;Email;Mail
Phone                  Mail -> Phone;Mail
                           Mail -> Mail
              Email    Mail -> Email;Mail

So semi-colons only occur if there's a value present and not at all if there's only one value present.
I hope that makes sense and displays correctly.

Carl

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.