Join Strings [TEXTJOIN]

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

  • Was this Helpful ?
  • YesNo
Relevant topics
Merge Strings [CONCAT]
Joins two or more text strings into one. Syntax CONCAT (“text1”, [“text2”], ...) Note: The required separator ...
Join or Leave a Teamwork Project
To join or leave a Teamwork project, you must be online. Join Typically, you will join a Teamwork project and remain joined in, for the full ...