CONCATENATE

The CONCATENATE Function

Function Group: Text

CONCATENATE appends strings to one another.

Syntax

CONCATENATE(arg1, [arg2...])

• arg1 is a string
• arg2 is optional, and also a string
• CONCATENATE can take an arbitrary number of arguments

Uses

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)

This would return "Toyota-A31z056.

Other Examples

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

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