Join Function

Join Function

---

Class

Microsoft.VisualBasic.Strings

Syntax

 result = Join(   sourcearray   , [   delimiter   ]) 

sourcearray (required; String or Object array)

Array whose elements are to be concatenated

delimiter (optional; String)

Character used to delimit the individual values in the string

Return Value

String

Description

Concatenates an array of values into a delimited string using a specified delimiter

Rules at a Glance

• If no delimiter is specified, the space character is used as a delimiter.

• If you want to concatenate numeric or other nonstring values in sourcearray , use an Object array. If, for example, you specify a numeric data type for sourcearray , the function will generate a compiler error.

Programming Tips and Gotchas

The Join function is ideal for quickly and efficiently writing out a comma-delimited text file from an array of values.