Concatenates the values of corresponding elements in two dynamic arrays.
function concatenates the value of each element in dynarray1
to the corresponding element in dynarray2
. It then returns a dynamic array containing the results of these concatenations. If a dynamic array element contains an empty string or an element is missing, no concatenation is performed for that element, and the element value from the other dynamic array is returned.
For two elements to be concatenated, they must be on the same dynamic array level. For example, you cannot concatenate a value mark (@VM) dynamic array element to a subvalue mark (@SM) dynamic array element.
Caché MVBasic converts numbers to canonical form (resolving signs, removing leading and trailing zeros, removing a leading plus sign, removing a trailing decimal point) before concatenating. Caché MVBasic does not
convert numeric strings to canonical form before concatenating.
If the two dynamic arrays have different numbers of elements, the returned dynamic array has the number of elements of the longer dynamic array. By default, the shorter dynamic array is padded with null string ("") value elements for the purpose of the concatenation operation. You can use the REUSE
function to concatenate a default value (instead of the null string) when the dynamic arrays differ in length.
You can use the REUSE
function with CATS
to concatenate the same value to all of the elements of a dynamic array. You can use the SPLICE
function to concatenate the elements of two dynamic arrays, supplying a separator character (or string of characters) that is inserted between the components of each element.
The following example uses the CATS
function to concatenate the elements of two dynamic arrays:
! returns AaaýBbbýCccýDdd
The following example concatenates two dynamic arrays of different lengths containing empty strings and missing elements:
! returns AaaýýccýDddýýff