Split

Use this function in case of multiple inputs for one global variable.

Compatibility

Available as of IDEA version 9.0

Syntax

Split(expression as String, delimiter as String)

Parameters

expression

Expression containing substrings and delimiters. If the expression is a zero-length string ("") Split returns a single-element array containing the empty expression string.

delimiter

String character(s) used to identify substring limits. This parameter can not be omitted. If delimiter is a zero-length string, a single-element array containing the entire expression string is returned. If the delimiter can not be found in expression Split returns only one element.

Example

Sub Test() 
	Dim a() As String 
	a = Split("", "") 
	MsgBox UBound(a) & Chr(10) & LBound(a) & Chr(10) & "#" & a(LBound(a)) & "#" 

	Dim b() As String 
	b = Split("abc||def||ghi||jkl", "") 
	MsgBox UBound(b) & Chr(10) & LBound(b) & Chr(10) & "#" & b(LBound(b)) & "#" 

	Dim c() As String 
	c = Split("abc||def||ghi||jkl", ";") 
	MsgBox UBound(c) & Chr(10) & LBound(c) & Chr(10) & "#" & c(LBound(c)) & "#" 

	Dim d() As String 
	d = Split("abc||def||ghi||jkl", "||") 
	MsgBox UBound(d) & Chr(10) & LBound(d) & Chr(10) & "#" & d(LBound(d)) & "#" 
End Sub

Copy example