Function: split()

Splits a string where a separator occurs, returning a list of substrings.

Syntax

split(string, separator)

Note that the separator is expressed as a regular expression. This means that you can use any pattern that can be expressed as a regular expression as a separator. But also that you must escape any special characters of regular expressions if you are using these as plain text (e.g. you must use "\\|" to use | as a separator). See examples below.

Examples

split("one,two,three",",")

returns ["one","two","three"].

split("one::two::three","::")

returns ["one","two","three"].

split("one::two::","::")

Returns ["one","two",""].

split("::::","::")

Returns ["","",""].

split("field1|field2|field3","\\|")

Returns ["field1","field2","field3"].

split("some text1more text3final text","[0-9]")

This will split the string at any single digit between 0 and 9. Returns ["some text","more text","final text"].

See Also

• Functions