Hi, talk2riya15.

Maybe you can try RAQ Report[/url], for it provides a great number of string functions for users. Of course, split() is one of them.

Syntax:

split( srcExp,sepExp{,boolExp})

Argument:

srcExp The string to be split.

sepExp The separator.

boolExp The parameter option which decides whether to split with the separator between two quotation marks, or brackets. True means to split, while false means not. The default value is false.

Examples

(1) =split("ab;cd;ef;tg;tt",";")

The return value is ["ab","cd","ef","tg","tt"].

(2) =split("ab;c'd;e'f;tg;tt",";",false)

The return value is ["ab","c'd;e'f","tg","tt"].

(3) =split("ab;c[d;e]f;tg;tt",";",true)

The return value is ["ab","c[d","e]f","tg","tt"].