Help

Solution to concatenate specific fields only

Topic Labels: Base design
392 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Brian_Tanner
4 - Data Explorer
4 - Data Explorer

Hello,

I would greatly appreciate your help finding a solution to concatenate each of the following fields while ignoring fields which contain (just) the letter “X”. (I am using “X” to denote empty instead of leaving the filed empty).

FYI. This formula works for concatenating all fields while ignoring the blank ones.

IF({Login Companies}, " " & {Login Companies}) &
IF({Login Titles}, " " & {Login Titles}) &
IF({Login Persons}, " " & {Login Persons}) &
IF({Login Places}, " " & {Login Places}) &
IF({Login Differentiators}, " " & {Login Differentiators})

Many thanks!!!

0 Replies 0