get for filters

Extract data using a cell path.

Signature

> get (cell_path) ...rest --ignore-errors --sensitive

Parameters

  • cell_path: the cell path to the data
  • ...rest: additional cell paths
  • --ignore-errors (-i): when there are empty cells, instead of erroring out, replace them with nothing
  • --sensitive (-s): get path in a case sensitive manner

Notes

This is equivalent to using the cell path access syntax: $env.OS is the same as $env | get OS.

If multiple cell paths are given, this will produce a list of values.

Examples

Get an item from a list

> [0 1 2] | get 1
1

Get a column from a table

> [{A: A0}] | get A
╭───┬────╮
│ 0 │ A0 │
╰───┴────╯

Get a cell from a table

> [{A: A0}] | get 0.A
A0

Extract the name of the 3rd record in a list (same as ls | $in.name)

> ls | get name.2

Extract the name of the 3rd record in a list

> ls | get 2.name

Extract the cpu list from the sys information record

> sys | get cpu

Getting Path/PATH in a case insensitive way

> $env | get paTH

Getting Path in a case sensitive way, won't work for 'PATH'

> $env | get -s Path