SPLIT

Split a text

Description

Splits a text into a list of sliced texts. The separator parameter specifies the characters within the text at which the splits will be done. If the separator is an empty text, the result is an array of single characters.

Function signature

SPLIT(text: String, pattern: String, maxslices: Number) => Array

Parameter

Description

Text

Text to split

Pattern

Token that splits the text

Max slices

Maximum number of slices to which the list is split

Examples

Formula

Return value

SPLIT("Foo Bar", " ")

["Foo","Bar"]

SPLIT("Foo", "")

["F","o","o"]

SPLIT("Foo Bar", "bbb")

["Foo Bar"]

SPLIT("Foo Bar Baz xxx", " ", 3)

["Foo","Bar","Baz xxx"]