CONCATENATE

CONCATENATE (not to be confused with CONCAT) appends strings together.

Function category: Text

Syntax

CONCATENATE(arg1, [arg2...])

CONCATENATE can take an arbitrary number of additional arguments.

Arguments

Description

arg1

A string.

arg2

Optional. Same as arg1.

Examples

Example 1: Combine information

Let's say we're given a response with some vehicle information that looks like this:

{
"data":{
"vehicles":{
"vehicle_1":{
"make":"Toyota",
"vin":"A31z056"
}
}
}
}

If we want to combine the information on vehicle_1 into a meta-vehicle tag, we could do so by using the CONCATENATE function.

CONCATENATE(data.vehicle_1.make, "-", data.vehicle_1.vin) = "Toyota-A31z056"

Example 2: Merge strings

Concatenate can also take an array of strings, which it will merge into a single string.

CONCATENATE({"a","a","a","a"}) = "aaaa"