csv_extract function - Materialize

csv_extract returns individual component columns from a column containing a CSV file formatted as a string.

Signatures

{{% include-syntax file="examples/sql_functions/csv_extract" example="syntax" %}}

Parameter	Type	Description
num_csv_col	`int`	The number of columns in the CSV string.
col_name	`string`	The name of the column containing the CSV string.

EXTRACT returns string columns.

Create a table where one column is in CSV format and insert some rows:

mzsql

CREATE TABLE t (id int, data string);
INSERT INTO t
  VALUES (1, 'some,data'), (2, 'more,data'), (3, 'also,data');

Extract the component columns from the table column which is a CSV string, sorted by column id:

mzsql

SELECT csv.* FROM t, csv_extract(2, data) csv
  ORDER BY t.id;

nofmt

 column1 | column2
---------+---------
 also    | data
 more    | data
 some    | data
(3 rows)