Note This function is new with Domino Release 6.

Syntax

Join(sourceArray, [delimiter])

Elements

sourceArray

One-dimensional Array containing the substrings to be concatenated. sourceArray can be an array of Strings, or an array of Variants. If sourceArray is an array of Variants, Join will attempt to convert any non-string elements to Strings.

Optional String containing separation character(s) for the concatenated Strings

Join returns a String containing the elements of sourceArray with delimiter between elements, or with the space character " " as a separator if delimiter is not specified.

Usage

Join creates a String that will hold the concatenation of sourceArray. Join then iterates through sourceArray, With each iteration, Join converts the next element of sourceArray to a String, if necessary, and appends it to the concatenation String. If more elements remain in sourceArray, a delimeter (either " " or the specified value) is appended to the concatenation String and Join continues to iterate. After all elements of sourceArray have been concatenated, Join returns the concatenation String.

Error handling

Join will throw a Run-time Type mismatch if:

• an element in a variant array cannot be coerced to a string.
• the delimiter is set to nothing.
• the array passed in is not of either type string or variant.
• a list is passed instead of an array.
• the array passed in contains an element set to nothing.
• the array passed in has not been properly initialized.

Join will throw a run-time Invalid Use of Null error if the array passed in contains an element set to null or if the delimiter is set to null.

Note Join is an alias of Implode and is identical in every way.

Language cross-reference

@Implode function in formula language

See Also

LotusScript Language Reference: I through L
Implode function

Glossary