csvtool

> Utility to filter and extract data from CSV formatted sources.

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}

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

-- Response ended

-- Page fetched on Tue May 21 00:09:00 2024