Hide

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again.

Delete that bloated snippets file you've been using and share your personal repository with the world. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

If you have a new feature suggestion or find a bug, please get in touch via http://commandlinefu.uservoice.com/

Get involved!

You can sign-in using OpenID credentials, or register a traditional username and password.

OpenID
or
Sign in Register

First-time OpenID users will be automatically assigned a username which can be changed after signing in.

Hide

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

Hide

News

2011-03-12 - Confoo 2011 presentation
Slides are available from the commandlinefu presentation at Confoo 2011: http://presentations.codeinthehole.com/confoo2011/
2011-01-04 - Moderation now required for new commands
To try and put and end to the spamming, new commands require moderation before they will appear on the site.
2010-12-27 - Apologies for not banning the trolls sooner
Have been away from the interwebs over Christmas. Will be more vigilant henceforth.
2010-09-24 - OAuth and pagination problems fixed
Apologies for the delay in getting Twitter's OAuth supported. Annoying pagination gremlin also fixed.
Hide

Tags

Hide

Functions

Hide

Credits

Site by David Winterbottom (user root).

Commands using column from sorted by
Terminal - Commands using column - 29 results
for i in {0..255}; do echo -e "\e[38;05;${i}m\\\e[38;05;${i}m"; done | column -c 80 -s ' '; echo -e "\e[m"
2013-07-05 07:16:19
User: derv82
Functions: column echo
Tags: zsh
0
Up
Down
Show numerical values for each of the 256 colors in ZSH

Prints an easy-to-copy color code for each color.

Show sample output | Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
history | awk '{CMD[$4]++;count++;} END { for (a in CMD )print CMD[a] " " CMD[a]/count*100 "% " a }' | sort -nr | nl | column -t | head -n 10
2013-07-05 02:38:04
User: jasee
Functions: awk column head nl sort
0
Up
Down
statistic of the frequnce of your command from your history。

perhaps you should use CMD[$2] instead of CMD[$4]

Show sample output | Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
for code in $(seq -w 0 255); do for attr in 0 1; do printf "%s-%03s %bTest%b\n" "${attr}" "${code}" "\e[${attr};38;05;${code}m" "\e[m"; done; done | column -c $((COLUMNS*2))
2013-01-13 18:23:44
User: claudius
Functions: column printf seq
Tags: bash color colors
0
Up
Down
Show numerical values for each of the 256 colors in bash for bold and normal fonts

Shows the ?rendering? for each of the 256 colours in both the bold and normal variant. Using seq is helpful to get even lines, passing $((COLUMNS*2)) to column sort-of-handles the nonprintable characters.

Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
sed 's/#.*//' /etc/fstab | column -t
2012-08-17 12:56:31
User: jlaunay
Functions: column sed
-3
Up
Down
list all available disks and disk partitions
Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
fdisk -l /dev/sda | grep -E sda[0-9]+ | sed s/*// | awk '{printf ("%s %f ",$1,$2/512); if($2%512){ print "BAD" }else {print "Good"} }' | column -t
2012-05-18 08:34:36
User: The_IceMan_Blog
Functions: awk column fdisk grep sed
Tags: Linux partition ssd alignment hdd
1
Up
Down
Check if you partition are aligned

To get most of you HDD/SSD driver you need to make sure you partition are aligned, if not the speed penalty can be up to 50% slower!

this simple one liner will check to see if each partition start sector is divided by 512

you need to change sda with your driver

if you find the one of your partitions is not aligned use gparted to move the start sector of the partition to be divided of 512

Show sample output | Comments (1) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
sudo ps aux --sort:rss | awk '{print $2"\t"$11": "$6/1024" MB"}' | column -t | less
2011-12-08 17:23:18
User: threv
Functions: awk column ps sudo
Tags: memory usage Linux ps awk, sort
0
Up
Down
Find and sort by Resident Size of each process on the system in MB
Show sample output | Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
curl -u username --silent "https://mail.google.com/mail/feed/atom" | awk 'BEGIN{FS="\n";RS="(</entry>\n)?<entry>"}NR!=1{print "\033[1;31m"$9"\033[0;32m ("$10")\033[0m:\t\033[1;33m"$2"\033[0m"}' | sed -e 's,<[^>]*>,,g' | column -t -s $'\t'
2011-10-15 23:15:52
User: frntn
Functions: awk column sed
Tags: Linux sed awk column curl rss gmail
2
Up
Down
Check your unread Gmail from the command line

Just an alternative with more advanced formating for readability purpose. It now uses colors (too much for me but it's a kind of proof-of-concept), and adjust columns.

Show sample output | Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
cat file.csv | perl -pe 'if($. == 1) {@h = split(/;/); $i = 1 ; map { $_ = $i; $i++ } @h; print join(" ;", @h) , "\n"} ; s/(^|;);/$1 ;/g' | column -ts\; | less -S
2011-08-31 12:52:02
User: bashrc
Functions: cat column less perl
Tags: column
0
Up
Down
format txt as table not joining empty columns adding header with column numbers

This version now adds a header with consecutive numbering.

Show sample output | Comments (1) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
column -tns: /etc/passwd
2011-08-31 10:47:04
User: bashrc
Functions: column
Tags: column
23
Up
Down
format txt as table not joining empty columns

-n switch keeps empty columns

If your distribution does not ship with a recent column version that supports -n you can use this alternative:

perl -pe 's/(^|;);/$1 ;/g' file.csv | column -ts\; | less -S

Change the delimiter to your liking.

Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
cat /etc/passwd | column -nts:
2011-08-31 02:08:20
User: kev
Functions: cat column
Tags: column
2
Up
Down
format txt as table
Show sample output | Comments (3) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
pacman -Qi $(pacman -Qq)|grep 'Name\|Size'| cut -d: -f2 | paste - - | column -t | sort -nk2
2011-05-03 13:02:06
User: minus
Functions: column cut grep paste sort
Tags: archlinux arch linux arch.linux pacman packages
0
Up
Down
Arch Linux sort installed packages by size
Comments (1) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
df -PH|column -t
2011-04-13 21:13:14
User: bakhru
Functions: column df
3
Up
Down
df without line wrap on long FS name
Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
df -P | column -t
2011-04-09 13:12:46
User: fossilet
Functions: column df
16
Up
Down
df without line wrap on long FS name

-P uses the POSIX output format, which makes information on each file system always printed on exactly one line. "column -t" makes a table from the input.

Show sample output | Comments (4) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
egrep '__NR_' /usr/include/asm/unistd_`getconf -a | awk '$1~/^WORD/{print $2}'`.h | sed -e 's/^#define __NR_//' | column -t
2011-03-04 15:09:40
User: cicatriz
Functions: awk column egrep sed
Tags: assembly nasm
-1
Up
Down
List of syscalls (for 32/64 bits systems)
Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
awk -F $'\t' '{printf $1 LS $2 LS $3 LS $4 LS $5; for (i = 7; i < NF; i++) printf $i "\t"; printf "\n--\n";}' LS=$'\n' 'Ad report.tsv' | column -t -s $'\t'
2011-02-28 10:52:16
User: zhangweiwu
Functions: awk column printf
-1
Up
Down
collapse first five fields of Google Adwords export .tsv file into a single field

The exported TSV file of Google Adwords' first five columns are text, they usually should collapse into one cell, a multi-line text cell, but there is no guaranteed way to represent line-break within cells for .tsv file format, thus Google split it to 5 columns.

The problem is, with 5 columns of text, there are hardly space to put additional fields while maintain printable output.

This script collapses the first five columns of each row into one single multi-line text cell, for console output or direct send to printer.

Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
l=10;for((i=0;i<$l;i++));do eval "a$i=($(pv=1;v=1;for((j=0;j<$l;j++));do [ $i -eq 0 -o $j -eq 0 ]&&{ v=1 && pv=1; }||v=$((pv+a$((i-1))[$((j))]));echo -n "$v ";pv=$v;done;));";eval "echo \"\${a$i[@]}\"";done | column -t;
2011-02-11 17:00:20
User: glaudiston
Functions: column eval
0
Up
Down
Pascal's triangle

see: http://en.wikipedia.org/wiki/Pascal%27s_triangle

Show sample output | Comments (7) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
paste <(pacman -Q | awk '{ print $1; }' | xargs pacman -Qi | grep 'Size' | awk '{ print $4$5; }') <(pacman -Q | awk '{print $1; }') | sort -n | column -t
2011-01-07 18:43:18
User: BruceLEET
Functions: awk column grep paste sort xargs
Tags: archlinux arch linux arch.linux pacman packages
4
Up
Down
Arch Linux sort installed packages by size

This one-liner will output installed packages sorted by size in Kilobytes.

Show sample output | Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
for i in {0..255}; do echo -e "\e[38;05;${i}m${i}"; done | column -c 80 -s ' '; echo -e "\e[m"
2010-07-21 17:30:36
User: cout
Functions: column echo
Tags: bash color column colors
7
Up
Down
Show numerical values for each of the 256 colors in bash

I like the other three versions but one uses nested loops and another prints every color on a separate line. Both versions fail to reset colors before giving the prompt back.

This version uses the column command to print a table so all the colors fit on one screen. It also resets colors back to normal before as a last step.

Comments (1) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
statt(){ C=c;stat --h|sed '/Th/,/NO/!d;/%/!d'|while read l;do p=${l/% */};[ $p == %Z ]&&C=fc&&echo ^FS:^;echo "`stat -$C $p \"$1\"` ^$p^${l#%* }";done|column -ts^; }
2010-06-11 23:31:03
User: AskApache
Functions: column read sed
Tags: bash sed ls file column read while loop function GNU/Linux stat askapache sh
3
Up
Down
STAT Function showing ALL info, stat options, and descriptions

This shows every bit of information that stat can get for any file, dir, fifo, etc. It's great because it also shows the format and explains it for each format option.

If you just want stat help, create this handy alias 'stath' to display all format options with explanations.

alias stath="stat --h|sed '/Th/,/NO/!d;/%/!d'"

To display on 2 lines:

( F=/etc/screenrc N=c IFS=$'\n'; for L in $(sed 's/%Z./%Z\n/'<<<`stat --h|sed -n '/^ *%/s/^ *%\(.\).*$/\1:%\1/p'`); do G=$(echo "stat -$N '$L' \"$F\""); eval $G; N=fc;done; )

For a similarly powerful stat-like function optimized for pretty output (and can sort by any field), check out the "lll" function

http://www.commandlinefu.com/commands/view/5815/advanced-ls-output-using-find-for-formattedsortable-file-stat-info

From my .bash_profile ->

http://www.askapache.com/linux-unix/bash_profile-functions-advanced-shell.html

Show sample output | Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
alias sorth='sort --help|sed -n "/^ *-[^-]/s/^ *\(-[^ ]* -[^ ]*\) *\(.*\)/\1:\2/p"|column -ts":"'
2010-06-10 21:30:31
User: AskApache
Functions: alias column sed
Tags: bash sort sed uniq alias column sorting reverse help askapache sh fields unique buffer
3
Up
Down
View advanced Sort options, Quick Reference Help Alias

Once you get into advanced/optimized scripts, functions, or cli usage, you will use the sort command alot. The options are difficult to master/memorize however, and when you use sort commands as much as I do (some examples below), it's useful to have the help available with a simple alias. I love this alias as I never seem to remember all the options for sort, and I use sort like crazy (much better than uniq for example).

# Sorts by file permissions

find . -maxdepth 1 -printf '%.5m %10M %p\n' | sort -k1 -r -g -bS 20%

00761 drwxrw---x ./tmp

00755 drwxr-xr-x .

00701 drwx-----x ./askapache-m

00644 -rw-r--r-- ./.htaccess

# Shows uniq history fast

history 1000 | sed 's/^[0-9 ]*//' | sort -fubdS 50%

exec bash -lxv

export TERM=putty-256color

Taken from my http://www.askapache.com/linux-unix/bash_profile-functions-advanced-shell.html

Show sample output | Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
alias dateh='date --help|sed -n "/^ *%%/,/^ *%Z/p"|while read l;do F=${l/% */}; date +%$F:"|'"'"'${F//%n/ }'"'"'|${l#* }";done|sed "s/\ *|\ */|/g" |column -s "|" -t'
2010-04-21 01:22:18
User: AskApache
Functions: alias column date read sed
Tags: bash sed alias column read while date loop for substitution askapache sh POSIX locale parameter
19
Up
Down
View all date formats, Quick Reference Help Alias

If you have used bash for any scripting, you've used the date command alot. It's perfect for using as a way to create filename's dynamically within aliases,functions, and commands like below.. This is actually an update to my first alias, since a few commenters (below) had good observations on what was wrong with my first command.

# creating a date-based ssh-key for askapache.github.com

ssh-keygen -f ~/.ssh/`date +git-$USER@$HOSTNAME-%m-%d-%g` -C 'webmaster@askapache.com' # /home/gpl/.ssh/git-gplnet@askapache.github.com-04-22-10

# create a tar+gzip backup of the current directory

tar -czf $(date +$HOME/.backups/%m-%d-%g-%R-`sed -u 's/\//#/g' <<< $PWD`.tgz) . # tar -czf /home/gpl/.backups/04-22-10-01:13-#home#gpl#.rr#src.tgz .

I personally find myself having to reference

date --help

quite a bit as a result. So this nice alias saves me a lot of time. This is one bdash mofo. Works in sh and bash (posix), but will likely need to be changed for other shells due to the parameter substitution going on.. Just extend the sed command, I prefer sed to pretty much everything anyways.. but it's always preferable to put in the extra effort to go for as much builtin use as you can. Otherwise it's not a top one-liner, it's a lazyboy recliner.

Here's the old version:

alias dateh='date --help|sed "/^ *%%/,/^ *%Z/!d;s/ \+/ /g"|while read l;do date "+ %${l/% */}_${l/% */}_${l#* }";done|column -s_ -t'

This trick from my [ http://www.askapache.com/linux-unix/bash_profile-functions-advanced-shell.html bash_profile ]

Show sample output | Comments (5) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
phonelogs() { grep "$1" /var/log/asterisk/cdr-csv/Master.csv | cut -d',' -f 2,3,11,12 --output-delimiter=" " | sed 's/"//g' | cut -d' ' -f 1,2,3,4,6 | column -t; }
2010-03-28 08:30:46
User: SuperJediWombat
Functions: column cut grep sed
Tags: asterisk
3
Up
Down
Print Asterisk phone logs

Prints a log of phonecalls placed from/to an asterisk server, formated into an easily readable table.

You can use partial number/queue matches, or use .* to match everything.

Show sample output | Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
alias ips='ip a | awk '\''/inet /&&!/ lo/{print $NF,$2}'\'' | column -t'
2010-03-06 20:33:04
User: zolden
Functions: alias awk column
3
Up
Down
print all network interfaces' names and IPv4 addresses

ifconfig can't properly display interface's name longer 9 symbols,also it can't show IPs added thru ip command, so 'ip' should be used instead. This alias properly shows long names, bond interfaces and all interface aliases. loopback interface is ignored, since its IP is obvious

Show sample output | Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
python -c 'import sys,csv; c = csv.reader(sys.stdin); [sys.stdout.write("^M".join(map(repr,r))+"\n") for r in c];' <tmp/test.csv | column -s '^M' -t
2010-02-01 14:57:25
User: pykler
Functions: c++ column python
Tags: CSV
1
Up
Down
Pretty Print a simple csv in the command line

Will handle pretty much all types of CSV Files.

The ^M character is typed on the command line using Ctrl-V Ctrl-M and can be replaced with any character that does not appear inside the CSV.

Tips for simpler CSV files:

* If newlines are not placed within a csv cell then you can replace `map(repr, r)` with r

Show sample output | Comments (1) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate
/sbin/ip -f inet addr | sed -rn 's/.*inet ([^ ]+).*(eth[[:digit:]]*(:[[:digit:]]+)?)/\2 \1/p' | column -t
2009-12-17 19:48:28
User: owen
Functions: column sed
1
Up
Down
Read just the IP address of a device
Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate