Hello! I have an expression where I'm trying to concatenate two columns. For their values I would like to have a slash (/) between them. However, I don't want the slash if either values are blank, only if both are filled. Could someone please help? Thank you for the help in advance.
Here is my expression:
[NOTE]&" / "&[CONDITION]
Solved! Go to Solution.
IF(
AND(ISNOTBLANK([NOTE]), ISNOTBLANK([CONDITION])),
[NOTE]&" / "&[CONDITION],
[NOTE]&" "&[CONDITION]
)
IF(
AND(ISNOTBLANK([NOTE]), ISNOTBLANK([CONDITION])),
[NOTE]&" / "&[CONDITION],
[NOTE]&" "&[CONDITION]
)
isnt this working? the logic seems correct.
Yes!! Thank you so much, diogolupcosta. This worked!
May be more complexity that is warranted for your scenario, but here's an extensible technique to Concatenate values with a delimiter.
Thank you for chiming in, dbaum. I will look at this too. Seems complex but fascinating.
Btw, there will be a blank space if either of the two are blank, right?
Yes, it will be blank space if either are blank. For my use, this is fine.
TRIM([NOTE]&" "&[CONDITION])
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |