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 |