Concatenates all members of an Array of Strings and returns a string. Elements of the Array are separated by a delimiter, if provided, or the space character (" ").
Join( sourceArray , [delimiter])
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.
delimiter
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.
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.
Join will throw a Run-time Type mismatch if:
Join will throw a run-time Wrong Number of Dimensions error if the array is not one-dimensional.
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.
@Implode function in formula language