Translation specification for the STRTOK_SPLIT_TO_TABLE function to its Snowflake equivalent query
Last updated 10 months ago
Split a string into a table using the provided delimiters. For more information check .
[TD_SYSFNLIB.] STRTOK_SPLIT_TO_TABLE ( inkey, instring, delimiters ) RETURNS ( outkey, tokennum, token )
CREATE TABLE strtokTable ( col1 INTEGER, col2 VARCHAR(100) ); INSERT INTO strtokTable VALUES(4, 'hello-world-split-me'); INSERT INTO strtokTable VALUES(1, 'string$split$by$dollars');
CREATE OR REPLACE TABLE strtokTable ( col1 INTEGER, col2 VARCHAR(100) ) COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}' ; INSERT INTO strtokTable VALUES (4, 'hello-world-split-me'); INSERT INTO strtokTable VALUES (1, 'string$split$by$dollars');
SELECT outkey, tokennum, token FROM table(STRTOK_SPLIT_TO_TABLE(strtokTable.col1, strtokTable.col2, '-$') RETURNS (outkey INTEGER, tokennum INTEGER, token VARCHAR(100))) AS testTable ORDER BY outkey, tokennum;
outkey |tokennum | token | -------+---------+--------+ 1 |1 |string | -------+---------+--------+ 1 |2 |split | -------+---------+--------+ 1 |3 |by | -------+---------+--------+ 1 |4 |dollars | -------+---------+--------+ 4 |1 |hello | -------+---------+--------+ 4 |2 |world | -------+---------+--------+ 4 |3 |split | -------+---------+--------+ 4 |4 |me |
SELECT CAST(strtokTable.col1 AS INTEGER) AS outkey, CAST(INDEX AS INTEGER) AS tokennum, CAST(VALUE AS VARCHAR) AS token FROM strtokTable, table(STRTOK_SPLIT_TO_TABLE(strtokTable.col2, '-$')) AS testTable ORDER BY outkey, tokennum;
No known issues.
No related EWIs.