CONCAT

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 formulaOutput
CONCAT(Campaign, ", ", Campaign Code)Summer Sale, SS01
CONCAT('Browser: ', Browser, ' OS Version: ', OS version)Browser: Edge Version: 85.0.564.44

Related resources

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2026-02-19 UTC.