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

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:

» all commands
» commands with 3 up-votes (commandlinefu3)
» commands with 10 up-votes (commandlinefu10)
» commands tagged column

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

Functions

Hide

Credits

Site by David Winterbottom (user root).

Commands tagged column

Terminal - Commands tagged column - 19 results

cut -d: -f 1 names.txt

2012-06-26 19:28:25

User: ankush108

Functions: cut

Tags: column cut

Up
Down

Select columns in a file

Display the 1st field (employee name) from a colon delimited file

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

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.

awk '$3==$4' /etc/passwd

2011-09-15 19:13:18

User: totti

Functions: awk

Tags: file column print

Up
Down

Print all lines from a file that has the same N th and M th column

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

Up
Down

format txt as table not joining empty columns adding header with column numbers

This version now adds a header with consecutive numbering.

column -tns: /etc/passwd

2011-08-31 10:47:04

User: bashrc

Functions: column

Tags: column

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

Up
Down

format txt as table

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

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^; }

This is sample output - yours may be different.

[275:254 0:302] [davinci@www.askapache.com:0 +6] /etc
(2:32)$ statt screenrc
644                    %a Access rights in octal
-rw-r--r--             %A Access rights in human readable form
40                     %b Number of blocks allocated (see %B)
512                    %B The size in bytes of each block reported by %b
86                     %d Device number in decimal
56                     %D Device number in hex
81a4                   %f Raw mode in hex
regular file           %F File type
0                      %g Group ID of owner
root                   %G Group name of owner
1                      %h Number of hard links
80002387               %i Inode number
/etc/screenrc          %n File name
`/etc/screenrc'        %N Quoted file name with dereference if symbolic link
4096                   %o I/O block size
20102                  %s Total size, in bytes
0                      %t Major device type in hex
0                      %T Minor device type in hex
0                      %u User ID of owner
root                   %U User name of owner
2010-06-11 14:23:28    %x Time of last access
1276280608             %X Time of last access as seconds since Epoch
2010-06-11 14:23:28    %y Time of last modification
1276280608             %Y Time of last modification as seconds since Epoch
2010-06-11 16:42:43    %z Time of last change
FS:
Z                      %Z Time of last change as seconds since Epoch
12190296               %a Free blocks available to non-superuser
20971520               %b Total data blocks in file system
5242880                %c Total file nodes in file system
4540105                %d Free file nodes in file system
12190296               %f Free blocks in file system
0                      %i File System ID in hex
255                    %l Maximum length of filenames
/etc/screenrc          %n File name
4096                   %s Block size (for faster transfers)
4096                   %S Fundamental block size (for block counts)
565a4653               %t Type in hex
UNKNOWN (0x565a4653)   %T Type in human readable form

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

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

find $PWD -maxdepth 1 -printf '%.5m %10M %#9u:%-9g %#5U:%-5G [%AD | %TD | %CD] [%Y] %p\n'

2010-06-10 22:03:08

User: AskApache

Functions: find

Tags: bash sort find ls column sorting permissions function GNU/Linux pwd stat askapache sh printf GNU find

Up
Down

Advanced LS Output using Find for Formatted/Sortable File Stat info

I love this function because it tells me everything I want to know about files, more than stat, more than ls. It's very useful and infinitely expandable.

find $PWD -maxdepth 1 -printf '%.5m %10M %#9u:%-9g %#5U:%-5G [%AD | %TD | %CD] [%Y] %p\n' | sort -rgbS 50%

00761 drwxrw---x askapache:askapache 777:666 [06/10/10 | 06/10/10 | 06/10/10] [d] /web/cg/tmp

The key is:

# -printf '%.5m %10M %#9u:%-9g %#5U:%-5G [%AD | %TD | %CD] [%Y] %p\n'

which believe it or not took me hundreds of tweaking before I was happy with the output.

You can easily use this within a function to do whatever you want.. This simple function works recursively if you call it with -r as an argument, and sorts by file permissions.

lsl(){ O="-maxdepth 1";sed -n '/-r/!Q1'<<<$@ &&O=;find $PWD $O -printf '%.5m %10M %#9u:%-9g %#5U:%-5G  [%AD | %TD | %CD]  [%Y] %p\n'|sort -rgbS 50%; }

Personally I'm using this function because:

lll () { local a KS="1 -r -g"; sed -n '/-sort=/!Q1' <<< $@ && KS=`sed 's/.*-sort=$.*$/\1/g'<<<$@`; find $PWD -maxdepth 1 -printf '%.5m %10M %#9u:%-9g %#5U:%-5G [%AD | %TD | %CD] [%Y] %p\n'|sort -k$KS -bS 50%; }

# i can sort by user

lll -sort=3

# or sort by group reversed

lll -sort=4 -r

# and sort by modification time

lll -sort=6

If anyone wants to help me make this function handle multiple dirs/files like ls, go for it and I would appreciate it.. Something very minimal would be awesome.. maybe like:

for a; do lll $a; done

Note this uses the latest version of GNU find built from source, easy to build from gnu ftp tarball. Taken from my http://www.askapache.com/linux-unix/bash_profile-functions-advanced-shell.html

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

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

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'

This is sample output - yours may be different.

%%:     '%'                         a literal %
%a:     'Wed'                       locale's abbreviated weekday name (e.g., Sun)
%A:     'Wednesday'                 locale's full weekday name (e.g., Sunday)
%b:     'Mar'                       locale's abbreviated month name (e.g., Jan)
%B:     'March'                     locale's full month name (e.g., January)
%c:     'Wed Mar 27 23:50:06 2013'  locale's date and time (e.g., Thu Mar  3 23:05:25 2005)
%C:     '20'                        century; like 2013, except omit last two digits (e.g., 20)
%d:     '27'                        day of month (e.g., 01)
%D:     '03/27/13'                  date; same as 03/27/13
%e:     '27'                        day of month, space padded; same as 27
%F:     '2013-03-27'                full date; same as 2013-03-27
%g:     '13'                        last two digits of year of ISO week number (see 2013)
%G:     '2013'                      year of ISO week number (see 13); normally useful only with 13
%h:     'Mar'                       same as Mar
%H:     '23'                        hour (00..23)
%I:     '11'                        hour (01..12)
%j:     '086'                       day of year (001..366)
%k:     '23'                        hour, space padded ( 0..23); same as 23
%l:     '11'                        hour, space padded ( 1..12); same as 11
%m:     '03'                        month (01..12)
%M:     '50'                        minute (00..59)
%n:     ' '                         a newline
%N:     '853525313'                 nanoseconds (000000000..999999999)
%p:     'PM'                        locale's equivalent of either AM or PM; blank if not known
%P:     'pm'                        like PM, but lower case
%r:     '11:50:06 PM'               locale's 12-hour clock time (e.g., 11:11:04 PM)
%R:     '23:50'                     24-hour hour and minute; same as 23:50
%s:     '1364442606'                seconds since 1970-01-01 00:00:00 UTC
%S:     '06'                        second (00..60)
%t:     '       '                             a tab
%T:     '23:50:06'                  time; same as 23:50:06
%u:     '3'                         day of week (1..7); 1 is Monday
%U:     '12'                        week number of year, with Sunday as first day of week (00..53)
%V:     '13'                        ISO week number, with Monday as first day of week (01..53)
%w:     '3'                         day of week (0..6); 0 is Sunday
%W:     '12'                        week number of year, with Monday as first day of week (00..53)
%x:     '03/27/13'                  locale's date representation (e.g., 12/31/99)
%X:     '23:50:06'                  locale's time representation (e.g., 23:13:48)
%y:     '13'                        last two digits of year (00..99)
%Y:     '2013'                      year
%z:     '-0400'                     +hhmm numeric time zone (e.g., -0400)
%:z:    '-04:00'                    +hh:mm numeric time zone (e.g., -04:00)
%::z:   '-04:00:00'                 +hh:mm:ss numeric time zone (e.g., -04:00:00)
%:::z:  '-04'                       numeric time zone with : to necessary precision (e.g., -04, +05:30)
%Z:     'EDT'                       alphabetic time zone abbreviation (e.g., EDT)

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

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 ]

(printf "PERMISSIONS LINKS OWNER GROUP SIZE MONTH DAY HH:MM PROG-NAME\n" \ ; ls -l | sed 1d) | column -t

2009-10-08 11:53:38

User: opexxx

Functions: column ls printf sed

Tags: sed ls column printf

Up
Down

Using column to format a directory listing

echo "vertical text" | fold -1

2009-10-05 23:20:14

User: zude

Functions: echo fold

Tags: column headers redirection paste process substitution

Up
Down

Print text string vertically, one character per line.

Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate

echo "vertical text" | grep -o '.'

2009-09-11 03:45:04

User: dennisw

Functions: echo grep

Tags: column headers redirection paste process substitution

Up
Down

Print text string vertically, one character per line.

Define a function

vert () { echo $1 | grep -o '.'; }

Use it to print some column headers

paste <(vert several) <(vert parallel) <(vert vertical) <(vert "lines of") <(vert "text can") <(vert "be used") <(vert "for labels") <(vert "for columns") <(vert "of numbers")

perl -F',' -ane '$a += $F[3]; END { print $a }' test.csv

2009-08-11 15:08:58

User: coffeeaddict_nl

Functions: perl

Tags: awk column CSV sum

Up
Down

Sum columns from CSV column $COL

More of the same but with more elaborate perl-fu :-)

Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate

awk -F ',' '{ x = x + $4 } END { print x }' test.csv

2009-08-11 12:10:33

User: coffeeaddict_nl

Functions: awk

Tags: awk column CSV sum

Up
Down

Sum columns from CSV column $COL

Comments (3) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate

column -t /proc/mounts

2009-08-09 17:00:41

User: unixmonkey5049

Functions: column

Tags: Filesystem mount column

Up
Down

currently mounted filesystems in nice layout

since fuse mounts do not appear in /etc/mtab (fuse can't write there, dunno if it would if it could) this is propably a better way.

Comments (2) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate

perl -ne 'split /,/ ; $a+= $_[3]; END {print $a."\n";}' -f ./file.csv

2009-08-07 09:35:52

User: ioggstream

Functions: perl

Tags: column CSV sum

Up
Down

Sum columns from CSV column $COL

Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate

mount | column -t

2009-03-20 14:18:56

User: thechile

Functions: column mount

Tags: Filesystem mount column

214

Up
Down

currently mounted filesystems in nice layout

Particularly useful if you're mounting different drives, using the following command will allow you to see all the filesystems currently mounted on your computer and their respective specs with the added benefit of nice formatting.