from csv
for formats
Parse text as .csv and create table.
Signature
> from csv --separator --noheaders --no-infer --trim
Parameters
--separator {string}
: a character to separate columns, defaults to ','--noheaders
(-n)
: don't treat the first row as column names--no-infer
(-)
: no field type inferencing--trim {string}
: drop leading and trailing whitespaces around headers names and/or field values
Examples
Convert comma-separated data to a table
> "ColA,ColB
1,2" | from csv
╭───┬──────┬──────╮
│ # │ ColA │ ColB │
├───┼──────┼──────┤
│ 0 │ 1 │ 2 │
╰───┴──────┴──────╯
Convert comma-separated data to a table, ignoring headers
> open data.txt | from csv --noheaders
Convert comma-separated data to a table, ignoring headers
> open data.txt | from csv -n
Convert semicolon-separated data to a table
> open data.txt | from csv --separator ';'
Convert semicolon-separated data to a table, dropping all possible whitespaces around header names and field values
> open data.txt | from csv --trim all
Convert semicolon-separated data to a table, dropping all possible whitespaces around header names
> open data.txt | from csv --trim headers
Convert semicolon-separated data to a table, dropping all possible whitespaces around field values
> open data.txt | from csv --trim fields