Join

Returns a Boolean value indicating whether an expression references a valid Automation object.

Syntax
      Join(list[, delimiter])

Key
   list       A one-dimensional array containing substrings to be joined.

   delimiter  A string character used to separate the substrings in the
              returned string. If omitted, the space character (" ") is used.
              If delimiter is a zero-length string, all items in the list are
              concatenated with no delimiters.

Example

join the substrings of MyArray:

Dim MyString
Dim MyArray(3)

MyArray(0) = "Mr."
MyArray(1) = "John "
MyArray(2) = "Doe "
MyArray(3) = "III"

MyString = Join(MyArray) ' MyString contains "Mr. John Doe III".

“There's zero correlation between being the best talker and having the best ideas” ~ Susan Cain

Related:

Array - Add values to an Array variable
Split - Parse a string of delimited values into an array


© Copyright SS64.com 1999-2014
Some rights reserved