So in the absence of a Case function, here's what I've done so far as
a calculated solution. Note that the data I want to concatenate is in
cells U3, V3, W3, and X3. In Y3, I put the following:
=U3 & IF(NOT(isempty(U3)),";","") & V3 & IF(NOT(isempty(V3)),";","") &
W3 & IF(NOT(isempty(W3)),";","") & X3
The idea is that I put together U3, a semicolon if U3 isn't empty (and
nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a
semicolon if W3 isn't empty, and X3. If any of the cells is empty,
nothing will be added until the next cell that has data.
Unfortunately, I'm getting a #NAME? error. I'm assuming some kind of
syntax error. Any words of wisdom?
Thanks a ton all.
On 5/15/13 5:13 PM, Dan Lewis wrote:
On 05/15/2013 04: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.
I just checked the available functions in Calc. The "Case"
function does not appear among them. "Case When" is available in Base
database queries though.