Join Function

Returns a string created by joining a number of substrings contained in an array.

Syntax

Join(list[, delimiter])

Arguments:

• List: Required. One-dimensional array containing substrings to be joined.
• Delimiter: Optional. String characters are 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.

The following examples illustrate the use of the Join function.

days=Array("Sun","Mon","Tue","Wed","Thu","Fri","Sat")
Join(days)		'Output-> Sun Mon Tue Wed Thu Fri Sat
Join(days,",")		'Output-> Sun,Mon,Tue,Wed,Thu,Fri,Sat
Join(days," ### ")	'Output-> Sun ### Mon ### Tue ### Wed ### Thu ### Fri ### Sat
Join(days,"")		'Output-> SunMonTueWedThuFriSats