The String type has an instance method, Split, that splits the instance string into an array of substrings. The problem with this method is that it can only use single characters as a separator, not a string. What if you separator is “{tab}—{tab}” or something else? It turns out that also the System.Text.RegularExpressions.Regex class has a Split method (static) that allows you do the splitting using a string as separator. Here’s an example with “{sep}” as the seaprator string:
Dim input As String = "this is{sep}my input string{sep}to test the " _ & "RegEx's{sep}Split method!"Dim output As String() = System.Text.RegularExpressions.Regex.Split(input, _ "{sep}")For Each token As String In output Debug.WriteLine(token)Next