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