16.20 - STRTOK_SPLIT_TO_TABLE - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Purpose

Splits strings into a table of tokens based on the provided delimiter(s) string.

STRTOK_SPLIT_TO_TABLE has similar semantics to the standard C/C++ library STRTOK function.

Syntax



TD_SYSFNLIB.
Name of the database where the function is located.
inkey
A numeric or character expresssion.
instring
If instring is NULL, NULL is returned.
delimiters
A character string or string expression.
If delimiters is NULL, NULL is returned.
If not specified, the value defaults to a space character.
outkey
A numeric or character expresssion.
tokennum
A character argument.
The token from the input string in the same character set as instring.
token
A character expression.