TOKEN: Extracting a Token From a String

The TOKEN function extracts a token (substring) based on a token number and a delimiter character.

Syntax: How to Extract a Token From a String

TOKEN(string, delimiter, number)

where:

string

Fixed length alphanumeric

Is the character string from which to extract the token.

delimiter

Fixed length alphanumeric

Is a single character delimiter.

number

Integer

Is the token number to extract.

TOKEN extracts the second token from the PRODUCT_SUBCATEG column, where the delimiter is a blank:

TOKEN(PRODUCT_SUBCATEG,' ',2)

For iPod Docking Station, the result is Docking.