Split Function:-The Split function will separates a string into substrings and creates a one-dimensional array where each substring is an element.

Syntax:-

Slit(Expression, Delimiter, Count, Compare(optional))

The Split function separates a string into substrings and creates a one-dimensional array where each substring is an element.

Example: -

mystring = "How is velmuruganqa blogs?"

myarray = Split(mystring," ",2,1)   ' here delimiter is space

myarray(0)
myarray(1)

a=myarray(0)  'output is =How
b=myarray(1)  'output is =is

----

Here 2 is nothing but number of count to be occur as array

Compare VALUE	DESCRIPTION
0	Binary comparison
1	Text Comparison
2	Compare information inside database