Joins two or more text strings into one string, separated by a given delimiter.
If IgnoreIfEmpty is True, the result will ignore empty strings.
Syntax
TEXTJOIN (“Delimiter”, IgnoreIfEmpty, “Text1”, “Text2”, ...)
Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.
Data Types of the Arguments
Delimiter and Text: String
Ignore if Empty: True/False
Data Type of the Result
String
Example
For each element, list its ID plus Zone Name plus Renovation Status.
The Delimiter consists of a comma and a space.
Expression
TEXTJOIN (“, ”, TRUE, Element ID, Related Zone Name, Renovation Status)
Result
SW-002, Kitchen, To Be Demolished
Notes
TEXTJOIN is similar to Merge Strings [CONCAT].
Compared to CONCAT, TEXTJOIN has the following additional features:
- add a specific delimiter character between each string automatically
- option to ignore empty strings