SPLIT Function                                                                                                                           

Returns a zero-based, one-dimensional array containing a specified number of substrings.

SPLIT(expression,delimiter)

Arguments

expression         String expression containing substrings and delimiters. If expression is a zero-length string, Split returns an empty array, that is, an array with no elements and no data.

delimiter            String character used to identify substring limits. If omitted, the space character (" ") is assumed to be the delimiter. If delimiter is a zero-length string, a single-element array containing the entire expression string is returned.

Remarks

None

Example

DIM value as string

DIM datastring[] as string

value= "matt,john,hello"

DIM sep as string

sep = ","

datastring=split(value,sep)

PRINT datastring[0]

PRINT datastring[1]

PRINT datastring[2]