Description
The CONCAT function combines multiple data types (e.g., text, numbers, dates) into one continuous text string without automatically adding a delimiter.
Usage
The function is used to concatenate one or more values into a single text string.
Syntax:CONCAT(condition1, [condition2], …)
Examples
-
Concatenate with a Colon and Space:
CONCAT(#[ID], ": ", #[Name])Combines the values in the ID and Name fields, separated by
:. The colon and space are added manually within the function.Output Example:
123: John Doe -
Concatenate with a Dash and Space:
CONCAT(#[Frequency], " - ", #[Start Date])Combines the values in the Frequency and Start Date fields, separated by
-. The dash and space are added manually.Output Example:
Monthly - 01/01/2024
Inputs
| Argument | Data Type | Description |
|---|---|---|
| condition1 | Text, Date, Number | The first value to concatenate. |
| [condition2] | Text, Date, Number | (Optional) Additional values to concatenate. |
Returns
Type: Text
- Produces a single concatenated text string.