Merge Strings [CONCAT]

Joins two or more text strings into one.

Syntax

CONCAT (“text1”, [“text2”], ...)

Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.

Data Types of the Arguments

String

Data Type of the Result

String

Example

Create a property called “Door Context ID”, consisting of a door’s Hotlink Master ID plus its Related Zone Number. (Both are String-type properties.)

The two strings should be separated by a dash.

Expression

CONCAT (Hotlink Master ID,”-”, Related Zone Number)

Result

Room 213-6

Notes

Don’t forget that a Property can be applied to an element (including Hotlink elements) only if the Property is available to that element.

The Evaluate function (from Property Manager) does not work on Hotlink Elements. However, the expression involving Hotlink element properties is correctly evaluated in Interactive Schedule, in Element Settings, on the Element Information Palette, and any other interface, provided that the Property is valid and available.

CONCAT is similar to Join Strings [TEXTJOIN]. Use Join Strings [TEXTJOIN] if you want to specify an automatic delimiter between all text strings, and to ignore empty strings.

For another example using CONCAT, see Example 3: Expand Property with Descriptive Text String.