Tuesday, August 10, 2010

Visual Basic String Function : Join

Purpose : The Join function returns a string created by concatenating all the values with in array

Syntax :
Join ( ListArray , [ Delimiter ] )

List Array : A one-dimensional array containing the substring values that will be concatenated
Delimiter : A string value that separates the substring in ListArray . If the argument is omitted , the values are concatenated with no delimiters.

Dim sString
Dim vArray(2)
vArray(0) = "Mr."
vArray(1) = "Arvind"
vArray(2) = "Nahar"
sString = Join(vArray , "+ " )

The result of sString will be " Mr. + Arvind + Nahar "

No comments:

Post a Comment