DE

↑ ↓ select, Enter open, Esc close

Filter CSV rows by the value in a column

harmlessText processingalle
Adjust the values, the command updates live
user@server
awk -F';' -v c=3 -v w='active' 'NR == 1 || $c == w' export.csv

Splits each line at the given character and prints it if the column exactly matches the value. The first line is always printed so the column headings are kept. For Excel exports created with a German locale, the semicolon is the usual delimiter.

Note: This is a simple split at the delimiter: quoted fields that contain the delimiter themselves are split incorrectly. If the values are quoted, the quotes must also be part of the value searched for.

Also searched as

  • filter csv file command line
  • awk filter csv by column value
  • extract rows with specific value from csv

Related one-liners

All in Text processing

Print lines where a column value exceeds a threshold

$awk -v c=10 -v min=5000000 '$c + 0 > min + 0' /var/www/vhosts/system/example.com/logs/access_ssl_log
harmlessText processing

Calculate the average, minimum and maximum of a column

$awk -v c=2 'NR == 1 {min = max = $c} {s += $c; if ($c < min) min = $c; if ($c > max) max = $c} END {if (NR) printf "n=%d avg=%.2f min=%s max=%s\n", NR, s/NR, min, max}' measurements.txt
harmlessText processing

Convert a JSON array to CSV with a header row

$jq -r '(.[0] | keys_unsorted) as $k | $k, (.[] | [.[$k[]]]) | @csv' plugins.json > plugins.csv
cautionText processing

Filter a JSON array by a field value

$jq '[.[] | select(.status == "active")]' plugins.json
harmlessText processing

Remove duplicate lines without changing the order

$awk '!seen[$0]++' list.txt
harmlessText processing

Sum the numbers in a column with awk

$awk -v c=10 '{s += $c} END {print s}' /var/www/vhosts/system/example.com/logs/access_ssl_log
harmlessText processing

Read first, then run.

The commands on myline.de act directly on servers, files and databases. A wrong path or placeholder can delete data irreversibly or make a server unreachable.

  • All commands are provided without warranty and are not tested on every system.
  • Understand what a command does before running it, and check every placeholder.
  • Make a backup first and, if possible, try it on a test system.
  • You run commands at your own risk. Liability for damages is excluded to the extent permitted by law.