SPLIT("John Smith", " ") produces a two-item list containing John and Smith.
SPLIT(LIST("Banana, Apricot, Grapes"), ", ") produces a three-item list: Banana, Apricot, Grapes.
SPLIT( some-text , delimiter )
- some-text (any textual type): The text to be split into parts.
- delimiter (any textual type): The delimiter between parts.
A list of Text values: the parts of some-text that occurred around delimiter.