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

1
SPLIT(text: String, pattern: String, maxslices: Number) => Array
Copied!
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"]
Last modified 1yr ago
Export as PDF
Copy link