Returns a list of text values divided around a specified delimiter.
Sample usage
SPLIT("John Smith", " ")
produces a two-item list containing John
and Smith
.
SPLIT("Banana, Apricot, Grapes", ", ")
produces a three-item list: Banana
, Apricot
, Grapes
.
SPLIT(LIST("Banana", "Apricot", "Grapes"), ",")
produces a three-item list: Banana
, Apricot
, Grapes
. See also: LIST()
SPLIT(TEXT({"Banana", "Apricot", "Grapes"}), " , ")
produces a three-item list: Banana
, Apricot
, Grapes
. See also: TEXT()
Common problems
The first argument to SPLIT()
should be a textual value. If not provided a textual value, the non-textual value will be converted to Text
before processing.
Of particular note, list types (List
and EnumList
) will be converted to Text
by joining the component values with a single comma (,
). For instance, the list LIST("Banana", "Apricot", "Grapes")
will be processed by SPLIT()
as if entered as "Banana,Apricot,Grapes"
.
The approach SPLIT()
uses differs from how list values are converted to Text
in other contexts. To get the other approach, use CONCATENATE()
or TEXT()
to manually convert the list to Text
. For instance, CONCATENATE(LIST("Banana", "Apricot", "Grapes"))
will be processed by SPLIT()
as if entered as "Banana , Apricot , Grapes"
, with the typical space-comma-space separator.
See also: CONCATENATE()
, TEXT()
Syntax
SPLIT(text, delimiter)
text
- Any textual type that will be split into parts.
delimiter
- Any textual type that specifies the delimiter between parts.