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

csvgrep

  • Filter CSV rows with string and pattern matching.
    Included in csvkit.
    More information: <https://csvkit.readthedocs.io/en/latest/scripts/csvgrep.html>.
  • Trick copyright: tl;dr; <https://github.com/tldr-pages/tldr>

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

click the source code to copy install csvgrep on any operating system with command-not-found.com