CONCAT
The following section describes the syntax and usage of the CONCAT function in ActivityInfo.
Description
The CONCAT function is used to concatenate (i.e. stick together) multiple strings (or text values).
Syntax
CONCAT(strings...)
| Argument | Required | Description |
|---|---|---|
| strings... |
Yes | The text values you wish to concatenate. |
Result
- The resulting concatenation of the text values.
- NA if the fields cannot be concatenated, or if they are empty.
Example
We will be using the CONCAT function to merge multiple text fields into a single text field.
Arguments
We will be using a Text Field and a Multi-line Text Field:
- "Text Field" (with code "text")
- "Narrative Field" (with code "multi")
We will also be using a Constant value "_". This will allow us to clearly separate the text from the two fields in our concatenated result.
Formula
CONCAT(text, "_", multi)
Results
