Commands using column | commandlinefu.com

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 using 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).

Terminal - Commands using column - 37 results

sc query state= all | awk '/SERVICE_NAME/{printf"%s:",$2;getline;gsub(/DISP.*:\ /,"");printf"%s\n",$0}' | column -ts\:

2015-02-15 22:35:10

User: lowjax

Functions: awk column

Tags: windows cygwin sc query windows services

Up
Down

Output Windows services in a neatly formated list (cygwin)

Outputs Windows Services service name and display name using "sc query", pipes the output to "awk" for processing, then "column" for formatting.

List All Services:

sc query state= all | awk '/SERVICE_NAME/{printf"%s:",$2;getline;gsub(/DISP.*:\ /,"");printf"%s\n",$0}' | column -ts\:

List Started Services:

sc query | awk '/SERVICE_NAME/{printf"%s:",$2;getline;gsub(/DISP.*:\ /,"");printf"%s\n",$0}' | column -ts\:

List Stopped Services:

sc query state= inactive| awk '/SERVICE_NAME/{printf"%s:",$2;getline;gsub(/DISP.*:\ /,"");printf"%s\n",$0}' | column -ts\:

ps axo pcpu,args | awk '/[p]hp.*pool/ { sums[$4] += $1 } END { for (pool in sums) { print sums[pool], pool } }' | sort -rn | column -t

2014-12-11 05:31:04

User: phunehehe

Functions: awk column ps sort

Tags: PHP ps

Up
Down

List PHP-FPM pools by total CPU usage

docker ps | sed -e 's/ /\+/g' -e 's/CONTAINER ID/CONTAINER_ID/' | tr -s '+' '\t' | q -t 'select c1,substr(c7, 0, 40),c2,c6 from -' | column -t

2014-06-06 07:20:36

User: akaivola

Functions: column ps sed tr

Tags: docker docker ps

Up
Down

human readable docker ps output

When you run a lot of containers the built in docker ps output becomes unreadable. This command formats the output to be easier on the eyes.

Requires q (https://github.com/harelba/q) text as data.

awk '$1=="Host"{$1="";H=substr($0,2)};$1=="HostName"{print H,"$",$2}' ~/.ssh/config | column -s '$' -t

2014-05-24 20:51:47

User: wejn

Functions: awk column

Tags: awk column

Up
Down

Extract shortcuts and hostnames from .ssh/config

Spits out table that shows your Host->HostName aliases in ~/.ssh/config

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

netstat -pnut -W | column -t -s $'\t'

2014-05-03 00:48:53

User: Nadiar

Functions: column netstat

Tags: column netstat wide

Up
Down

Show complete URL in netstat output

This takes all of the tab spaces, and uses column to put them into the appropriately sized table.

for i in {1..256};do p=" $i";echo -e "${p: -3} \\0$(($i/64*100+$i%64/8*10+$i%8))";done|cat -t|column -c120

2014-04-04 16:54:53

User: AskApache

Functions: cat column echo

Tags: echo column ascii for octal askapache chart

Up
Down

Print ASCII Character Chart

Prints out an ascii chart using builtin bash! Then formats using cat -t and column.

The best part is:

echo -e "${p: -3} \\0$(( $i/64*100 + $i%64/8*10 + $i%8 ))";

From: http://www.askapache.com/linux/ascii-codes-and-reference.html

netstat -tup -W | column -t

2014-01-08 22:39:01

User: b_t

Functions: column netstat

Tags: column netstat wide

Up
Down

Show complete URL in netstat output

The -W switch of netstat makes it print complete URL of the connections, which otherwise by default

is truncated to fit its default column size.

Now to compensate for irregular column sizes, pipe the output to column (-t switch of column prints in tabular form). The only downside to this part is that the very first row, the header, goes pear shape.

bind -P | grep -v "is not" | sed -e 's/can be found on/:/' | column -s: -t

2013-12-19 12:30:19

User: leni536

Functions: column grep sed

Tags: bash shortcut bind

Up
Down

List all bash shortcuts

Shows all available keyboard bindings in bash. Pretty printing.

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

Up
Down

Show numerical values for each of the 256 colors in ZSH

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

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

Up
Down

statistic of the frequnce of your command from your history。

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

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

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

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

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

Up
Down

Find and sort by Resident Size of each process on the system in MB

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.

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

2011-05-03 13:02:06

User: minus

Functions: column cut grep paste sort

Tags: archlinux arch linux arch.linux pacman packages

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

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

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.

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

Up
Down

Pascal's triangle

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

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

Up
Down

Arch Linux sort installed packages by size

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

1 2 >