`split column` for strings

Split a string into multiple columns using a separator.

Signature

> split column {flags} (separator) ...rest

Flags

--collapse-empty, -c: Remove empty columns.
--number, -n {int}: Split into maximum number of items.
--regex, -r: Separator is a regular expression.

Parameters

separator: The character or string that denotes what separates columns.
...rest: Column names to give the new columns.

Input/output types:

input	output
string	table
list<string>	table

Examples

Split a string into columns by the specified separator.

> 'a--b--c' | split column '--'
╭───┬─────────┬─────────┬─────────╮
│ # │ column0 │ column1 │ column2 │
├───┼─────────┼─────────┼─────────┤
│ 0 │ a       │ b       │ c       │
╰───┴─────────┴─────────┴─────────╯

Split a string into columns of char and remove the empty columns.

> 'abc' | split column --collapse-empty ''
╭───┬─────────┬─────────┬─────────╮
│ # │ column0 │ column1 │ column2 │
├───┼─────────┼─────────┼─────────┤
│ 0 │ a       │ b       │ c       │
╰───┴─────────┴─────────┴─────────╯

Split a list of strings into a table.

> ['a-b' 'c-d'] | split column -
╭───┬─────────┬─────────╮
│ # │ column0 │ column1 │
├───┼─────────┼─────────┤
│ 0 │ a       │ b       │
│ 1 │ c       │ d       │
╰───┴─────────┴─────────╯

Split a list of strings into a table, ignoring padding.

> ['a -  b' 'c  -    d'] | split column --regex '\s*-\s*'
╭───┬─────────┬─────────╮
│ # │ column0 │ column1 │
├───┼─────────┼─────────┤
│ 0 │ a       │ b       │
│ 1 │ c       │ d       │
╰───┴─────────┴─────────╯

Split into columns, last column may contain the delimiter.