STRTOK_SPLIT_TO_TABLE Function Example | Teradata Vantage - Example - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantageā„¢

If:

CREATE TABLE t (id integer, str varchar(256)character set unicode);

and:

INSERT INTO t VALUES (1,'Teradata-Warehouse 13.10 - Combine 2 powerful forms of business intelligence (BI).'); 

and:

insert into t values (2,'http://www.teradata.com/');

then:

SELECT d.* FROM TABLE (strtok_split_to_table(t.id, t.str, ' -/')
RETURNS (outkey integer, tokennum integer, token varchar(20)character set unicode) ) as d order by 1,2;
outkey   tokennum  token
-----------  -----------  --------------------------
          1            1  Teradata
          1            2  Warehouse
          1            3  13.10
          1            4  Combine
          1            5  2
          1            6  powerful
          1            7  forms
          1            8  of
          1            9  business
          1           10  intelligence
          1           11  (BI).
          2            1  http:
          2            2  www.teradata.com