Returns text that is the concatenation of two or more fields or expressions.
Sample usage
CONCAT(Campaign, ", ", Campaign Code)
Syntax
CONCAT( X, Y [, Z,...])
Parameters
X- literal text, a field, or an expression containing at least one field.Y- literal text, a field,or an expression containing at least one field.Z- literal text, a field, or an expression containing at least one field.
Notes
- Aggregated fields cannot be used as parameters.
Examples
In the following examples, note that you can use either single quotes or double quotes, but they must be used consistently.
| Example formula | Output |
|---|---|
CONCAT(Campaign, ", ", Campaign Code) |
Summer Sale, SS01 |
CONCAT('Browser: ', Browser, ' OS Version: ', OS version) |
Browser: Edge Version: 85.0.564.44 |