I would like to embed an IF statement in a concatenation like “IF {column1} is empty, show {column1}” AS IN:
concatenate ({column1}," “,IF {column1} is empty, show {column2},” ",{column3})
Is this possible?
I would like to embed an IF statement in a concatenation like “IF {column1} is empty, show {column1}” AS IN:
concatenate ({column1}," “,IF {column1} is empty, show {column2},” ",{column3})
Is this possible?
Yes, you can do this, but there is not “empty” function so if you are using text functions you can do…
CONCATENATE ({column1},IF(LEN({column1})>0," “,”“),{column2},IF(LEN({column2})>0,” “,”“),{column3},IF(LEN({column3})>0,” “,”")
or TRIM(CONCATENATE({column1}," “,{column2},” ",{column3}))
Hope this helps
Matthew
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.