Creates a one-dimensional array from the String passed.
|result||String array||Array resulting from breaking source into elements using delimiter as the field delimiter.|
|source||String||Source string to be parsed into an array.|
|delimiter||String||Optional field delimiter used to parse Source into array elements. If delimiter is omitted, then a space is used as the delimiter.|
Use the Split function to create a new String array from a list of elements (or fields) that are separated by a delimiter. If the optional parameter, delimiter, is not passed, a single space is assumed as the delimiter. If the delimiter is an empty string, the source string is split into characters.
According to Feedback Case 16302, Split may not work in all cases as documented here. For instance, if the application is running on a Japanese Windows system, Split returns an empty array when splitting by an empty string. To be on the safe side until this has been fixed, you should access the characters in a string using the Mid function instead, e.g. like this:
The first example specifies the comma delimiter and the second example uses the default delimiter. They place each field into an array element, producing a three-element array. The last example parses the string into individual characters.
anArray=Split("Adam Aardvark Accountant")
//First two using the alternate syntax:
Dim s as String
anArray=s.Split(",") //produces 3-element array
anArray=s.Split("") //produces array of individual characters, but should be avoided (see Bug note above)