Split
SPLIT(string[, delimiter[, count[, compare]]])
Description
SPLIT returns a one-dimensional array of strings of a specified length, created by dividing a single string where a specified delimiter occurs. The required parameter, string, is a valid string expression; if string is a zero-length string (""), SPLIT returns an empty array. The optional argument, delimiter, is a string expression whose first character is used to separate the substrings; if delimiter is a zero-length string (""), a single-element array containing the entire string is returned. The optional parameter, count, is a numeric expression that specifies the number of substrings to return; if count is not provided -1 is used as a default specifying that all substrings be returned. The optional parameter, compare, is used to specify the type of search performed.
Example
REM SPLIT Example 'SPLIT divides a string into substrings DIM List, Who, All, TopTwo List = "Eric,Kenny,Kyle,Stan" Who = SPLIT(List, ",") PRINT Who(0), Who(1), Who(2), Who(3) All = "First Second Third Fourth Fifth" TopTwo = SPLIT(All, " ") PRINT TopTwo(0), TopTwo(1)
Output
Eric Kenny Kyle Stan First Second
Related Items