Reference material for STRING_TO_ARRAY function
''
, the result is an array containing the entire original input string as a single element.NULL
, the string is split into individual characters, with one character per array element.Parameter | Description |
---|---|
<string> | The string to split. |
<delimiter> | The separator to split the string by. |
ARRAY(TEXT)
stephen70|esimpson|ruthgill|
at each |
character and returns the resulting array as nicknames
:
nicknames (ARRAY(TEXT)) |
---|
STRING_TO_ARRAY
with an empty delimiter, producing an array containing a single element which contains the input text:
size_one_array (ARRAY(TEXT)) |
---|
STRING_TO_ARRAY
with NULL
as the delimiter, splitting the text into individual characters:
single_characters (ARRAY(TEXT)) |
---|