JoinText

JoinText( A, I, separator, finalSeparator, default, textForNull )

Returns the elements of «A» (as text) concatenated along «I».

If any elements are numeric, they are converted to strings using the number format settings for the current node.

Null items are ignored, unless «textForNull» is specified.

Optional parameters

«separator»	:	text inserted between each item.
«finalSeparator»	:	Used instead of «separator» between the penultimate and final items.
«default»	:	(new in 4.4.3) The result value when there are no items to be joined. E.g., when all items are Null.
«textForNull»	:	(new in 4.4.3) When specified, Null items are not ignored, and the text provided is used.

Examples

Suppose A is the following array, indexed by J

J →	1	2	3	4	5
	"one"	"two"	"three"	"four"	"five"

Then:

JoinText(A,J)	→	"onetwothreefourfive"
JoinText(A,J,',')	→	"one,two,three,four,five"
JoinText(A,J,", "," and ")	→	"one, two, three, four and five"
JoinText(Exp(J^2),J,', ')	→	"2.718, 54.6, 8103, 8.886M, 72G"

Treatment of Null. Suppose B' is the following array indexed by J

J →	1	2	3	4	5
	"one"	«null»	"three"	«null»	"five"

JoinText(B,J,",")	→	"one,three,five"
JoinText(B,J,",",textForNull:"")	→	"one,,three,,five"
JoinText(B,J,",",textForNull:"NULL")	→	"one,NULL,three,NULL,five"
JoinText([Null,Null,Null])	→	""
JoinText([Null,Null,Null],default:null)	→	«null»
JoinText([])	→	""
JoinText([],default:"empty")	→	"empty"

See Also

• SplitText
• Text Concatenation Operator: &