CONCAT Operation

How to use the CONCAT Operation in formulas

Definition

Example 

Syntax Guide

Formula in Use

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.DESCRIPTION)

concat

Creating a bulleted description

CONCAT("•",$LABEL,"
","•",$LABEL,"
","•",$LABEL,"
","•",$LABEL)

compound-bullet-concat


What's Next

If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...

 

and please let us know 👇