How to use the CONCAT Operation in formulas
Definition
The CONCAT operation concatenates, or joins, two or more values.
Example
CONCAT(“HELLO”, “ “, “WORLD”)
Result:
HELLO WORLD
Syntax Guide
CONCAT(value1, value2,[value3],...)
value1 - The value to which value2 will be appended
value2 - The value to append to value1
value3, … - [OPTIONAL] Additional values to append
⚠️When using a multiselect attribute type, you will get brackets around your multiselect options if you use CONCAT. Try using the JOIN operation instead to remove the brackets.
Formula in Use
Creating a compound title
CONCAT($ATT.SLOGAN," ","|"," ",$ATT.SHORT_DESCRIPTION)
Creating a bulleted description
CONCAT("•",$LABEL,"
","•",$LABEL,"
","•",$LABEL,"
","•",$LABEL)
What's Next
- Learn more about how to write formulas
- Check out the LOWER operation
- Check out the MAP operation