csvgrep

Filter CSV rows with string and pattern matching. Included in csvkit. More information: <https://csvkit.readthedocs.io/en/latest/scripts/csvgrep.html>.

Install

All systems
curl cmd.cat/csvgrep.sh
Debian Debian
apt-get install csvkit
Ubuntu
apt-get install csvkit
image/svg+xml Kali Linux
apt-get install csvkit
Fedora
dnf install python3-csvkit
Windows (WSL2)
sudo apt-get update sudo apt-get install csvkit
OS X
brew install csvkit
Raspbian
apt-get install python3-csvkit

Filter CSV rows with string and pattern matching. Included in csvkit. More information: <https://csvkit.readthedocs.io/en/latest/scripts/csvgrep.html>.

  • 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

© tl;dr; authors and contributors