How to tokenize string by delimiters in teradata?

@cali_green 

In Teradata, you can tokenize a string by delimiters using the STRTOK function. The STRTOK function returns a token from a string based on a specified delimiter.

Here is an example of how you can use the STRTOK function to tokenize a string by delimiters:

1
2
3

SELECT STRTOK('apple,orange,banana', ',', 1) AS token1,
       STRTOK('apple,orange,banana', ',', 2) AS token2,
       STRTOK('apple,orange,banana', ',', 3) AS token3

In this example, the STRTOK function is used to tokenize the string 'apple,orange,banana' based on the delimiter ','. The first parameter is the input string, the second parameter is the delimiter, and the third parameter is the position of the token you want to retrieve.

Running the above query will return the following result:

1
2
3

token1  |   token2   |   token3
--------|------------|------------
apple   |   orange   |   banana

You can use the STRTOK function to tokenize a string by multiple delimiters by calling the function multiple times with different delimiters.