💾 Archived View for freeshell.de › tldr › csvtool.gmi captured on 2022-06-03 at 23:18:53. Gemini links have been rewritten to link to archived content

-=-=-=-=-=-=-

csvtool

Utility to filter and extract data from CSV formatted sources.

More information.

Extract the second column from a CSV file:

csvtool --column {2} {path/to/file.csv}

Extract the second and fourth columns from a CSV file:

csvtool --column {2,4} {path/to/file.csv}

Extract lines from a CSV file where the second column exactly matches 'Foo':

csvtool --column {2} --search '{^Foo$}' {path/to/file.csv}

Extract lines from a CSV file where the second column starts with 'Bar':

csvtool --column {2} --search '{^Bar}' {path/to/file.csv}

Find lines in a CSV file where the second column ends with 'Baz' and then extract the third and sixth columns:

csvtool --column {2} --search '{Baz$}' {path/to/file.csv} | csvtool --no-header --column {3,6}

Copyright © 2014—present the tldr-pages team and contributors.

This work is licensed under the Creative Commons Attribution 4.0 International License (CC-BY).

CC-BY