Split Text Into Words | TEXT_WORDS
Syntax
TEXT_WORDS( [value] )
Parameters
value
The TEXT to split.
If it is not a TEXT value, it will be converted to one with the STRING operation.
Return Value
An ARRAY of TEXT values.Description
Split a TEXT into words. This operation is equivalent to TEXT_SPLIT(value, "/\s+/")Examples
# VALUE is
# "Beware the Jabberwock, my son!"
TEXT_WORDS(VALUE)
# returns [
# "Beware",
# "the",
# "Jabberwock,",
# "my",
# "son!"
# ]
TEXT_WORDS("") # returns [""]
TEXT_WORDS(null) # returns [""]
TEXT_WORDS(1234) # returns ["1234"]