💾 Archived View for freeshell.de › tldr › csvgrep.gmi captured on 2023-11-04 at 12:21:44. Gemini links have been rewritten to link to archived content

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

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