CONCAT function

Synopsis
This function returns the concatenated string representation of 2 or more values.
Remarks
Variations
CONCAT(Value_1, ..., Value_n)
Returns the values passed as parameters as one string.
Details | Examples | Details and examples
Parameters
Value_1, ..., Value_n

Specifies the values to concatenate.

Supported types: String; Numeric; Boolean.
Returns
Returned types: String.
Examples
1.

The following example merges the values and returns "Number of blobs found: 22"

CONCAT("Number ", "of ", "blobs ", "found: ", BlobAnalysis.NumberFound)
2.

The following example returns an array of concatenated strings, where each element displays a formatted coordinate point, "(X, Y)". For example, [(12.0, 15.2), (5.8, 20.7)].

SELECT(PatternMatching.Occurrences, CONCAT("(", TOSTRING(Item.X, ":F1"), ", ", TOSTRING(Item.Y, ":F1"), ")"))