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>".