Concat

concat concatenates two or more strings.

Syntax

Copy
concat(expression1, expression2 [, expression3 ...])

Arguments

concat takes two or more string expressions as arguments.

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.

Return type

String

Examples

The following example concatenates three string fields and adds appropriate spacing.

Copy
concat(salutation, ' ', firstName, ' ', lastName)

The following are the given field values.

Copy
salutation     firstName          lastName
-------------------------------------------------------
Ms.            Li                  Juan
Dr.            Ana Carolina        Silva
Mr.            Nikhil              Jayashankar

For these field values, the following values are returned.

Copy
Ms. Li Juan
Dr. Ana Carolina Silva
Mr. Nikhil Jayashankar

The following example concatenates two string literals.

Copy
concat('Hello', 'world')

The following value is returned.

Copy
Helloworld