Commands using awk sorted by votes

Commands using awk (1,418)

sorted by

Revert all modified files in an SVN repo

This command allows you to revert every modified file one-by-one in a while loop, but also after "echo $file;" you can do any sort of processing you might want to add before the revert happens. Show Sample Output
This is sample output - yours may be different.
```
my/files.txt
Reverted 'my/files.txt'
```
0

svn status | grep "^M" | while read entry; do file=`echo $entry | awk '{print $2}'`; echo $file; svn revert $file; done

wsams · 2012-06-17 16:01:06 9
Number of connections per IP with range 24

cut -f1,2 - IP range 16 cut -f1,2,3 - IP range 24 cut -f1,2,3,4 - IP range 24 Show Sample Output
This is sample output - yours may be different.
```
      1 192.168.1.5
      5 192.168.1.2
      8 192.168.1.52
     15 192.168.1.3
     19 192.168.1.30
```
0

netstat -tn | grep :80 | awk '{print $5}'| grep -v ':80' | cut -f1 -d: |cut -f1,2,3 -d. | sort | uniq -c| sort -n

krishnan · 2012-06-26 08:29:37 3
Mute Master sound channel, printing only the percent volume
This is sample output - yours may be different.
0

amixer -c 0 set Master toggle | sed -n "$ p" | awk '{print $4}' | sed "s/[^0-9]//g"

dtsip · 2012-06-26 21:16:42 7
Unmuting master channel, printing only percent value, while suppressing other outputs
This is sample output - yours may be different.
0

amixer -c 0 set Master toggle | tail -1 | awk '{print $4}' | sed "s/[^0-9]//g" ; amixer -c 0 set Speaker toggle >/dev/null; amixer -c 0 set Front toggle >/dev/null

dtsip · 2012-06-26 21:18:07 5
Execute git submodule update in parallel with xargs
This is sample output - yours may be different.
0

git submodule status | awk '{print $2}' | xargs -P5 -n1 git submodule update --init

lox · 2012-06-27 19:26:56 3
Generate a password for website authentication that can be recreated each time you need to authenticate without saving the password

Create a bash function for easy reference webPassword() { echo $1 $2 | md5sum | awk '{print substr($0,0,10)}' } alias webpwd=webPassword Use like this. webpwd www.commandlinefu.com MyPetNameHere Show Sample Output
This is sample output - yours may be different.
```
$ echo http://www.TheWebSiteName.com privatekeyword | md5sum | awk '{print substr($0,0,10)}'

3ac2dd2389
```
0

echo http://www.TheWebSiteName.com privatekeyword | md5sum | awk '{print substr($0,0,10)}'

ertjies · 2012-06-28 11:32:08 3
Get the IP address
This is sample output - yours may be different.
0

ifconfig | grep "inet" | grep "broadcast" | awk '{print $2}'

wotan · 2012-07-13 01:24:42 3
Get the IP address

more variety
This is sample output - yours may be different.
0

ifconfig | grep "inet" | tail -1 | awk '{print $2}'

wotan · 2012-07-13 01:27:59 3
Get the IP address
This is sample output - yours may be different.
0

ip a s eth0 | awk '/inet / {print $2} | sed -e 's/\/..//g'

ilovespam · 2012-07-18 02:43:15 3
Get the IP address
This is sample output - yours may be different.
0

ip a s eth0 | awk -F"[/ ]+" '/inet / {print $3}'

ilovespam · 2012-07-18 02:47:12 3
Get Unique Hostnames from Apache Config Files

Get a list of all the unique hostnames from the apache configuration files. Handy to see what sites are running on a server. When i saw the command i had some ideas to make it shorter. Here is my version.
This is sample output - yours may be different.
0

egrep 'ServerAlias|ServerName' /etc/apache2/sites-enabled/*.conf | awk '{printf "%s\t%s\n",$2,$3}' | sed 's/www.//' | sort | uniq

staeff · 2012-07-25 12:51:15 3
Displays all the fields of a table, really usefull to run it inside editor (Emacs or vim)

You can execute this inside an editor to get all the fields inside your buffer and do the magic, really usefull when your tables contain a giant list of fields. Show Sample Output
This is sample output - yours may be different.
```
user@machine:~$ echo "describe information_schema.COLUMNS" | mysql -u root | awk '{print $1}' | grep -v Field
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
ORDINAL_POSITION
COLUMN_DEFAULT
IS_NULLABLE
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
CHARACTER_OCTET_LENGTH
NUMERIC_PRECISION
NUMERIC_SCALE
CHARACTER_SET_NAME
COLLATION_NAME
COLUMN_TYPE
COLUMN_KEY
EXTRA
PRIVILEGES
```
0

echo "DESCRIBE dbname.table_name" | mysql -u dbusername | awk '{print $1}' | grep -v Field

adauto · 2012-07-26 21:06:11 3
sum and average of requests responses times or sizes in Apache2 access log

Depending on your Apache access log configuration you may have to change the sum+=$11 to previous or next awk token. Beware, usually in access log last token is time of response in microseconds, penultimate token is size of response in bytes. You may use this command line to calculate sum and average of responses sizes. You can also refine the egrep regexp to match specific HTTP requests. Show Sample Output
This is sample output - yours may be different.
```
Tot=134020202(15201)
Avg=8816.54
```
0

egrep '.*(("STATUS)|("HEAD)).*' http_access.2012.07.18.log | awk '{sum+=$11; ++n} END {print "Tot="sum"("n")";print "Avg="sum/n}'

fanchok · 2012-07-27 12:18:29 3
Remove from PATH paths containing a string

If there are spaces won't work.
This is sample output - yours may be different.
0

export PATH= $(echo $PATH | tr ':' '\n' | awk '!/matching string/' | paste -sd:)

bugmenot · 2012-07-29 00:30:54 3

Display IP addresses Pidgin IM Client is connected to

lsof -p `pidof pidgin` | awk '{ print $9 }'|egrep `hostname` | grep -o ">[^:]\+:" | tr -d ":>" | while read line; do host $line; done;

NaN0 · 2012-08-08 14:47:20 3

Add executable bit to all shell scripts under current directory recursively.

Allows to change 'shell' compatible files execution bit even if their name is not *.sh
This is sample output - yours may be different.
0

find . -type f -exec file '{}' + | grep shell | awk -F':' '{print $1}' | xargs chmod u+x

llebegue · 2012-08-09 18:53:08 3
Kill all processes belonging to a user

Okay, commands like this are a bit of a personal peeve. awk(1) operates on a /pattern/ {action} paradigm and yet I see people leave out the /pattern/ portion of an awk command all the time, opting to use grep or sed instead. You'll save yourself some typing and time if you include the /pattern/ with your {action}.
This is sample output - yours may be different.
0

ps wwwwuax|awk '/command/ { printf("kill -9 %s\n",$2) }'|/bin/sh

jetdillo · 2012-08-14 21:44:38 4
Random (sfw, 1920x1080) wallpaper from wallbase.cc
This is sample output - yours may be different.
0

wget --no-use-server-timestamps $(curl $(curl http://wallbase.cc/random/23/eqeq/1920x1080/0/100/20 | grep 'wallpaper/' | awk -F'"' '{print $2}' | head -n1) | grep -A4 bigwall | grep img | awk -F'"' '{print $2}'); feh --bg-center $(ls -1t | head -n1)

yosh · 2012-08-14 22:06:27 3
Connected to first screen session created
This is sample output - yours may be different.
0

screen -x $(screen -ls | awk 'NR == 2 { print $1 }')

codecaine · 2012-08-17 02:03:26 4
list all available disks and disk partitions

grep -e "[sh]d[a-l]$" /proc/partitions | awk '{print $4}' # for disks only grep -e "[sh]d[a-l][0-9]\+" /proc/partitions | awk '{print $4}' # for partitions only Show Sample Output
This is sample output - yours may be different.
```
sda
sda1
sda2
sda3
sdb
sdb1
sdb2
sdb3
```
0

grep -e "[sh]d[a-l][0-9]\?" /proc/partitions | awk '{print $4}'

kro · 2012-08-17 13:15:46 6
Network Interfaces

Linux only Show Sample Output
This is sample output - yours may be different.
```
lo
eth0
```
0

awk '{print $1}' /proc/net/dev|grep :|sed "s/:.*//g"

kro · 2012-08-17 13:36:47 56

Look for free ip's in a given /24 subnet.

The command will make it easy to determine free IP ranges in a crowded sub-net. Show Sample Output

SUBNET="192.168.41" ; diff -y <(nmap -sP -n ${SUBNET}.0/24 | grep ${SUBNET}. | awk '{print $5}' | sort -t"." -k4 -n) <(for i in $(seq 1 254); do echo ${SUBNET}.$i; done)

michel_p · 2012-08-28 09:11:18 4

add untracked/changed items to a git repository before doing a commit and/or sending upstream

I came up with this because I don't have a problem remembering the big major changes I made deep inside my tree for a specific feature or bugfix but always manage to forget the trivial stuff I tweaked or touched along the way that needs to get pushed as well. Show Sample Output
This is sample output - yours may be different.
```
bash-3.2$ git status|awk '/modified:/ { printf("git add %s\n",$3) }; NF ==2 { printf("git add %s\n",$2) }'
git add Android/
git add Docs/
bash-3.2$bash-3.2$ git status
# On branch dev
# Changes to be committed:
#   (use "git reset HEAD <file>..." to unstage)
#
#       new file:   Android/.classpath
#       new file:   Android/.project
#       new file:   Android/AndroidManifest.xml
```
0

git status|awk '/modified:/ { printf("git add %s\n",$3) }; NF ==2 { printf("git add %s\n",$2) }'|sh

jetdillo · 2012-09-03 00:09:04 5

add untracked/changed items to a git repository before doing a commit and/or sending upstream

Uses the --porcelain option, which is garanteed to be stable among git versions and configurations - also, is way easier to parse. Show Sample Output

git status --porcelain | awk '{print $2}' | xargs git add

brandizzi · 2012-09-05 18:07:26 4

Get Current CPU Usage

Get the current cpu % usage on your system. Show Sample Output
This is sample output - yours may be different.
```
13.50
```
0

top -n2 -d 0.5 | grep ^Cpu | sed 's/[[:alpha:]%]*//g' | awk 'NR == 2 {printf("%.2f\n",100-$5)}'

wizzra · 2012-09-06 12:56:26 5
‹ First < 33 34 35 36 37 > Last ›

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. 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.

Share Your Commands

Check These Out

Print all the lines between 10 and 20 of a file

Similarly, if you want to print from 10 to the end of line you can use: sed -n '10,$p' filename This is especially useful if you are dealing with a large file. Sometimes you just want to extract a sample without opening the entire file. Credit goes to wbx & robert at the comments section of http://www.commandlinefu.com/commands/view/348/get-line1000-from-text.#comment

Find Duplicate Files (based on MD5 hash) -- For Mac OS X

This works on Mac OS X using the `md5` command instead of `md5sum`, which works similarly, but has a different output format. Note that this only prints the name of the duplicates, not the original file. This is handy because you can add `| xargs rm` to the end of the command to delete all the duplicates while leaving the original.

Which processes are listening on a specific port (e.g. port 80)

swap out "80" for your port of interest. Can use port number or named ports e.g. "http"

Convert seconds to [DD:][HH:]MM:SS

Converts any number of seconds into days, hours, minutes and seconds. sec2dhms() { declare -i SS="$1" D=$(( SS / 86400 )) H=$(( SS % 86400 / 3600 )) M=$(( SS % 3600 / 60 )) S=$(( SS % 60 )) [ "$D" -gt 0 ] && echo -n "${D}:" [ "$H" -gt 0 ] && printf "%02g:" "$H" printf "%02g:%02g\n" "$M" "$S" }

Check if it's OK to spawn tmux. Bool's Rools.

The command cechks if we are connected to a X11 console, if the $TERM var noct yet contains a "screen" derivat, and only then attachs to tmux. You could add a test for interactive shell [[ $- == *i* ]] but your .bashrc has that already, I bet.

Syntax Highlight your Perl code

This uses Text::Highlight to output the specified Perl file with syntax highlighting. A better alternative is my App::perlhl - find it on the CPAN: http://p3rl.org/App::perlhl

Exclude inserting a table from a sql import

Starting with a large MySQL dump file (*.sql) remove any lines that have inserts for the specified table. Sometimes one or two tables are very large and uneeded, eg. log tables. To exclude multiple tables you can get fancy with sed, or just run the command again on subsequently generated files.

Create a bunch of dummy text files

Which processes are listening on a specific port (e.g. port 80)

swap out "80" for your port of interest. Can use port number or named ports e.g. "http"

Which processes are listening on a specific port (e.g. port 80)

swap out "80" for your port of interest. Can use port number or named ports e.g. "http"

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 awk

Commands using awk (1,418) the last day the last week the last month all time sorted by date votes

What's this?

Check These Out

Stay in the loop…

Commands using awk (1,418)

sorted by