TextJoin2

Function

TextJoin2(rowDelimiter, colDelimiter, array)

rowDelimiter
colDelimiter
array

TextJoin2 is included by default in each file as part of the Text library.

 

See also:


Use

The TextJoin2() function combines the items in an array into a text value, with given delimiters between rows and columns.

The items in the array are expected to be text values, but if the items are number values, they will be converted to text values.

TextJoin() works similarly, but with only one given delimiter.

Examples
  • TextJoin2("__", "**", ["A", "B"; "C", "D"])  = "A**B__C**D"
  • TextJoin2("; ", " ", ["wish", "me"; "good", "morning"])  = "wish me; good morning"