CONCAT Operation

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

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