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.

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.

UpGuard checks and validates configurations for every major OS, network device, and cloud provider.

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

May 19, 2015 - A Look At The New Commandlinefu: I've put together a short writeup on what kind of newness you can expect from the next iteration of clfu. Check it out here.
March 2, 2015 - New Management: I'm Jon, I'll be maintaining and improving clfu. Thanks to David for building such a great resource!

Hide

Top Tags

awk, bash, curl, find, grep, Linux, sed

Hide

Functions

Terminal - Commands using column - 42 results

for y in {1..10}; do for x in {1..10}; do echo -n "| $x*$y=$((y*x)) "; done; echo; done|column -t

2016-09-07 12:31:18

User: lpalgarvio

Functions: column echo

Up
Down

Multiplication table

The multiplication table for math study

column -ts , /etc/openvpn/openvpn-status.log

2016-05-17 09:36:58

User: luxaeterna101

Functions: column

Up
Down

nice column format for openvpn servers log file

Formats nicely the Openvpn log file.

cat <file>|column -t

2015-05-30 18:56:34

User: bakhru

Functions: cat column

-11

Up
Down

display a tab separated file as columns

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

col_look(){ column -nts$'\t' "$1" | less -SN#2 }

2015-05-11 18:17:29

User: razerwolf

Functions: column less

-2

Up
Down

display a tab separated file as columns

Opens up a tab separated file in less with columns printed prettily

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

mosth() { history | awk '{CMD[$2]++;count++;}END { for (a in CMD)print CMD[a] " " CMD[a]/count*100 "% " a;}' | grep -v "./" | column -c3 -s " " -t | sort -nr | nl | head -n10; }

2015-05-11 17:41:55

User: nnsense

Functions: awk column grep head nl sort

Up
Down

Most used commands from history (without perl)

I copied this (let's be honest) somewhere on internet and I just made it as a function ready to be used as alias. It shows the 10 most used commands from history. This seems to be just another "most used commands from history", but hey.. this is a function!!! :D

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 (5) | 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 (2) | 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) [email protected] = 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 (4) | 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 (5) | 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

1 2 >