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"]