STRTOK Function Syntax | VantageCloud Lake - STRTOK Function Syntax - Teradata Vantage

[TD_SYSFNLIB.] STRTOK ( instring , delimiter , tokennum )

Syntax Elements

TD_SYSFNLIB.

Name of the database where the function is located.

instring

A character string or string expression.

If instring is NULL, NULL is returned.

delimiter

A list of delimiter characters. Each character in the string is considered a delimiter character.

If not specified, the value defaults to a space character.

tokennum

The ordinal token to return.

If not specified, the default value is 1.