to csv
For formats.
Convert table into .csv text .
Command Type
built-in
Signature
> to csv {flags}
Flags
--separator, -s {string}: A character to separate columns, defaults to ’,’.--noheaders, -n: Do not output the columns names as the first row.--columns {list<string>}: The names (in order) of the columns to use.
Input/output types:
| input | output |
|---|---|
| record | string |
| table | string |
Examples
Outputs a CSV string representing the contents of this table.
> [[foo bar]; [1 2]] | to csv
foo,bar
1,2
Outputs a CSV string representing the contents of this table.
> [[foo bar]; [1 2]] | to csv --separator ';'
foo;bar
1;2
Outputs a CSV string representing the contents of this record.
> {a: 1 b: 2} | to csv
a,b
1,2
Outputs a CSV stream with column names pre-determined.
> [[foo bar baz]; [1 2 3]] | to csv --columns [baz foo]
baz,foo
3,1
Ported from nushell/nushell.github.io. Copyright (c) 2021 Nushell Project. MIT License.