DE

↑ ↓ select, Enter open, Esc close

Align output as a table with column

harmlessText processingdebian, ubuntu
Adjust the values, the command updates live
user@server
column -t -s ':' /etc/passwd

Determines the width of each column and pads with spaces to produce a readable table. -s sets the delimiter, without it column splits on whitespace. Also works in pipes, for example mount | column -t.

Note: On Debian and Ubuntu, column comes from the bsdextrautils package. Empty fields between two delimiters are merged, with -n they are kept as separate columns.

Also searched as

  • align columns in terminal output
  • display csv as table in terminal
  • format messy command output linux

Related one-liners

All in Text processing

Pretty-print JSON with indentation and colors

$jq . composer.json
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

Compare two lists: what is missing from the second

$comm -23 <(sort -u all-domains.txt) <(sort -u backed-up-domains.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

Convert text to lowercase or uppercase

$tr '[:upper:]' '[:lower:]' < domains.txt
harmlessText processing

Count and sort lines across many files

$find /var/www/vhosts/example.com/httpdocs/wp-content/themes -type f -name '*.php' -exec wc -l {} + | sort -rn | head -n 20
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.