SPLICE Function

Concatenates the elements in two dynamic arrays, separating the concatenated elements with a delimiter.

Syntax

SPLICE(dynArray1, delimiter, dynArray2)

Syntax Elements

dynArray1, dynArray2
DataBasic expressions that evaluate to dynamic arrays.

delimiter A string that will be used to separate the concatenated elements.

Return Value

A dynamic array formed by combining dynArray1 and dynArray2. Each element contains the result of concatenating the element in dynArray1 with the corresponding element in dynArray2, separating the two with delimiter.

If an element of one dynamic array has no corresponding element in the other dynamic array, the element is returned prefixed or followed by delimiter as appropriate.

See Also

CATS function.

Example

ARY1 = 100:@AM:200:@AM:300:@VM:"ZA"
ARY2 = "X":@VM:"XA":@AM:"Y":@AM:"Z"
DELIM = ">"
NEWARY = SPLICE(ARY1, DELIM, ARY2)

Sets NEWARY to "100>XVM>XAAM200>YAM300>ZVMZA>".