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+unsubscr...@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