Split
- 19 May 2022
- 1 Minute to read
-
DarkLight
-
PDF
Split
- Updated on 19 May 2022
- 1 Minute to read
-
DarkLight
-
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?