Skip to main content

Concatenating Strings

AMPS provides the CONCAT function, that can be used for constructing strings.

CONCAT​

CONCAT​

CONCAT(string1, [string2, ...])

Takes any number of parameters and returns a string constructed from those parameters. The function can accept both XPath identifiers and literal values.

Parameters

  • string1: The first string.
  • string2: Optional. Additional strings to concatenate.

Returns

A single string that is the concatenation of all the parameters.

Example

The CONCAT function can be used in any AMPS expression that uses a string. For example, you could CONCAT in a filter as follows:

CONCAT(/firstName, " ", /lastName) = 'George Orwell'

CONCAT can be combined with other expressions, including conditional expressions. A mailingAddressName field in a view could be constructed as follows:

<Field>CONCAT(/firstName, " ", /lastName,
    IF(/suffix NOT NULL, CONCAT(", ", /suffix), "") )
    AS /mailingAddressName</Field>