CSVGREP(1) csvkit CSVGREP(1) (NAME) csvgrep - CSV (DESCRIPTION) : usage: csvgrep [-h] [-d DELIMITER] [-t] [-q QUOTECHAR] [-u {0,1,2,3}] [-b] [-p ESCAPECHAR] [-z FIELD_SIZE_LIMIT] [-e ENCODING] [-S] [-H] [-K SKIP_LINES] [-v] [-l] [--zero] [-V] [-n] [-c COLUMNS] [-m PATTERN] [-r REGEX] [-f MATCHFILE] [-i] [-a] [FILE] CSV. "grep" . positional arguments: FILE CSV . STDIN . optional arguments: -h, --help -n, --names CSV . -c COLUMNS, --columns COLUMNS "1,id,3-5". -m PATTERN, --match PATTERN . -r REGEX, --regex REGEX . -f MATCHFILE, --file MATCHFILE . ( ) . -i, --invert-match . -a, --any-match . : . : '-m' '-r' '-f' "" . (EXAMPLES) Illinois: csvgrep -c 1 -m ILLINOIS examples/realdata/FY09_EDU_Recipients_by_State.csv "I" : csvgrep -c 1 -r "^I" examples/realdata/FY09_EDU_Recipients_by_State.csv : csvgrep -c 1 -r "^$" -i examples/realdata/FY09_EDU_Recipients_by_State.csv : csvgrep -c 1 -r "(?i)illinois" examples/realdata/FY09_EDU_Recipients_by_State.csv (comment): printf "a,b\n1,2\n# a comment\n3,4" | csvgrep --invert-match -c1 -r '^#' (\x1e Record Separator (RS) ): csvgrep -m 22 -a -c 1- examples/realdata/FY09_EDU_Recipients_by_State.csv | csvformat -M $'\x1e' | xargs -d $'\x1e' -n1 sh -c 'echo $0 | csvcut -n' | grep 22 : . (AUTHORS) Christopher Groskopf (COPYRIGHT) 2016, Christopher Groskopf and James McKinney 2.2.0 August 16, 2024 CSVGREP(1)