split

Function: split()

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

Syntax

split(string, separator)

ArgumentTypeDescription
stringStringString to be split
separatorRegular ExpressionRegular expression representing the breakpoints in string where the splits should occur

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