csvgrep

Filter CSV rows with string and pattern matching.

Included in csvkit.

=> More information.

• Find rows that have a certain string in column 1:

csvgrep -c {1} -m {string_to_match} {data.csv}

• Find rows in which columns 3 or 4 match a certain regular expression:

csvgrep -c {3,4} -r {regular_expression} {data.csv}

• Find rows in which the "name" column does NOT include the string "John Doe":

csvgrep -i -c {name} -m "{John Doe}" {data.csv}

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