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

Another way to state this is I'd like a "Columns to Text" function, but 
where I can specify semi-colon as the separator and it won't place two 
separators together consecutively.

Thanks again,
Carl


On 5/15/13 4:16 PM, 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

--

Carl Paulsen

8 Hamilton Street

Dover, NH 03820

(603) 749-2310


--
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