csv_extract function
csv_extract returns individual component columns from a column containing a CSV file formatted as a string.
Signatures
| 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. |
Return value
EXTRACT returns string columns.
Example
Create a table where one column is in CSV format and insert some rows:
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:
SELECT csv.* FROM t, csv_extract(2, data) csv ORDER BY t.id; column1 | column2 ---------+--------- also | data more | data some | data (3 rows)