Split
  • 19 May 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Split

  • Dark
    Light
  • PDF

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"]

Was this article helpful?

What's Next