Commands using awk | 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.

Universal configuration monitoring and system of record for IT.

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 awk

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

Hide

Credits

Maintained by Jon H.

» [email protected]

Site originally by David Winterbottom (user root).

Psst. Open beta.

Wow, didn't really expect you to read this far down. The latest iteration of the site is in open beta. It's a gentle open beta-- not in prime-time just yet. It's being hosted over at UpGuard (link) and you are more than welcome to give it a shot. Couple things:

» The open beta is running a copy of the database that will not carry over to the final version. Don't post anything you don't mind losing.
» If you wish to use your user account, you will probably need to reset your password.

Your feedback is appreciated via the form on the beta page. Thanks! -Jon & CLFU Team

Terminal - Commands using awk - 1,210 results

awk 'NR%3==1' file

2010-01-08 18:52:24

User: point_to_null

Functions: awk

Up
Down

Every Nth line position # (AWK)

A better way to show the file lines 3n + 1

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

awk '{print NR,$0}'

2010-01-08 08:00:34

User: 4Aiur

Functions: awk

Up
Down

Prints line numbers

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

awk '{if (NR % 3 == 1) print $0}' foo > foo_every3_position1; awk '{if (NR % 3 == 2) print $0}' foo > foo_every3_position2; awk '{if (NR % 3 == 0) print $0}' foo > foo_every3_position3

2010-01-08 04:20:06

User: oshazard

Functions: awk

-1

Up
Down

Every Nth line position # (AWK)

awk extract every nth line.

Generic is:

awk '{if (NR % LINE == POSITION) print $0}' foo

where "last" position is always 0 (zero).

awk 'BEGIN{while (a++<50) s=s "-"; print s}'

2010-01-06 16:16:35

User: SuperFly

Functions: awk

Up
Down

Print a row of 50 hyphens

Change the number 50 to whatever number of characters you want. Change the character inside the double quotes to whatever you want printed.

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

for x in `ptree | awk '{print $1}'`; do pfiles $x | grep ${PORT} > /dev/null 2>&1; if [ x"$?" == "x0" ]; then ps -ef | grep $x | grep -v grep; fi; done 2> /dev/null

2010-01-05 17:02:23

User: bpfx

Functions: awk grep ps

Up
Down

Determine what process is listening on a port on Solaris, without lsof

Can use lsof, but since it's not part of the base OS, it's not always available.

pfiles -F /proc/* 2>/dev/null | awk '/^[0-9]+/{proc=$1};/[s]ockname: AF_INET/{print proc $0}'

2010-01-04 21:21:32

User: hunternet

Functions: awk

Up
Down

Solaris get PID socket

Command line to get which PID is opening a socket on IP and PORT.

Only useful under Solaris.

(bzcat BZIP2_FILES && cat TEXT_FILES) | grep -E "Invalid user|PAM" | grep -o -E "from .+" | awk '{print $2}' | sort | uniq >> /etc/hosts.deny

2010-01-03 04:41:51

User: jayhawkbabe

Functions: awk cat grep sort uniq

Up
Down

Block all IP addresses and domains that have attempted brute force SSH login to computer

Searches all log files (including archived bzip2 files) for invalid user and PAM authentication errors, both of which are indicative of brute force attempts at logging into computer. A list of all unique IP addresses and domain names is appended to hosts.deny. The command (and grep error messages) will work on Mac OS X 10.6, small adjustments may be needed for other OSs.

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

BACKUP_FILE_SIZE=`eval ls -l ${BACKUP_FILE} | awk {'print $5'}`; if [ $BACKUP_FILE_SIZE -le 20 ]; then echo "its empty"; else echo "its not empty"; fi

2009-12-29 08:34:37

User: Redrocket

Functions: awk echo ls

-2

Up
Down

Check if file is greater than 20 bytes, such as an empty gzip archive

If you gzip an empty file it becomes 20 bytes. Some backup checks i do check to see if the file is greater than zero size (-s flag) but this is no good here. Im sure someone has a better check than me for this? No check to see if file exists before checking it's size.

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

calc() { awk 'BEGIN { OFMT="%f"; print '"$*"'; exit}'; }

2009-12-25 19:08:16

User: cfajohnson

Functions: awk

Tags: calc calculation floating point

Up
Down

floating point shell calculator

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

$class=ExampleClass; $path=src; for constant in `grep ' const ' $class.php | awk '{print $2;}'`; do grep -r "$class::$constant" $path; done

2009-12-24 11:32:24

User: BluesDragon

Functions: awk grep

Tags: awk grep PHP

-2

Up
Down

Find all uses of PHP constants in a set of files

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

DIR=. ; FSTYPE=$(df -TP ${DIR} | grep -v Type | awk '{ print $2 }') ; echo "${FSTYPE}"

2009-12-22 14:01:50

User: unixhome

Functions: awk df echo grep

Up
Down

Test file system type before further commands execution

Exclude 400 client hosts with NFS auto-mounted home directories.

Easily modified for inclusion in your scripts.

curl -s search.twitter.com | awk -F'</?[^>]+>' '/\/intra\/trend\//{print $2}'

2009-12-22 01:01:02

User: putnamhill

Functions: awk

Tags: twitter awk curl

Up
Down

Print trending topics on Twitter

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

curl --silent search.twitter.com | sed -n '/div id=\"hot\"/,/div/p' | awk -F\> '{print $2}' | awk -F\< '{print $1}' | sed '/^$/d'

2009-12-21 21:29:34

User: allrightname

Functions: awk sed

Up
Down

Print trending topics on Twitter

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

ps -ylC httpd --sort:rss | awk '{ SUM += $8 } END { print SUM/1024 }'

2009-12-20 15:41:50

User: nasser

Functions: awk ps

Up
Down

Sum using awk

This command will show you amount of memory used by apache

awk '!x[$0]++' <file>

2009-12-20 02:33:21

User: din7

Functions: awk

Up
Down

Remove duplicate entries in a file without sorting.

Using awk, find duplicates in a file without sorting, which reorders the contents. awk will not reorder them, and still find and remove duplicates which you can then redirect into another file.

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

awk '/.*{$/{s[$1]=z[$1]=j+0}{l[j++]=$0}END{asorti(s);for(v in s){while(l[z[s[v]]]!~/}$/)print l[z[s[v]]++];print"}"ORS}}'

2009-12-19 16:38:33

User: pkrumins

Functions: awk

Up
Down

Awk one-liner that sorts a css file by selector

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

tar -cf - . | pv -s $(du -sb . | awk '{print $1}') | gzip > out.tgz

2009-12-18 17:09:08

User: opertinicy

Functions: awk du gzip tar

Tags: awk du tar gzip pv progress

Up
Down

copy working directory and compress it on-the-fly while showing progress

What happens here is we tell tar to create "-c" an archive of all files in current dir "." (recursively) and output the data to stdout "-f -". Next we specify the size "-s" to pv of all files in current dir. The "du -sb . | awk ?{print $1}?" returns number of bytes in current dir, and it gets fed as "-s" parameter to pv. Next we gzip the whole content and output the result to out.tgz file. This way "pv" knows how much data is still left to be processed and shows us that it will take yet another 4 mins 49 secs to finish.

Credit: Peteris Krumins http://www.catonmat.net/blog/unix-utilities-pipe-viewer/

awk -F":" '{ print $1 }' /etc/passwd | while read UU ; do STATUS=$(passwd -S ${UU} | grep locked 2>/dev/null) ; if [[ ! -z ${STATUS} ]] ; then echo "Account ${UU} is locked." ; fi ; done

2009-12-18 14:28:15

User: unixhome

Functions: awk echo grep passwd read

Up
Down

Sometimes you just want a quick way to find out if a certain user account is locked [Linux].

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

echo $LS_COLORS | sed 's/:/\n/g' | awk -F= '!/^$/{printf("%s \x1b[%smdemo\x1b[0m\n",$0,$2)}'

2009-12-15 01:17:46

User: bones7456

Functions: awk echo sed

Up
Down

show ls colors with demo

This can show all ls colors, with a demo.

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

zcat access_log.*.gz | awk '{print $7}' | sort | uniq -c | sort -n | tail -n 20

2009-12-11 09:36:30

User: tkb

Functions: awk sort tail uniq zcat

Tags: log apache zcat analysis

Up
Down

Analyse compressed Apache access logs for the most commonly requested pages

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

curl -sL 'dynamic.xkcd.com/comic/random/' | awk -F\" '/^<img/{printf("<?xml version=\"1.0\"?>\n<xkcd>\n<item>\n <title>%s</title>\n <comment>%s</comment>\n <image>%s</image>\n</item>\n</xkcd>\n", $6, $4, $2)}'

2009-12-09 15:02:32

User: putnamhill

Functions: awk

Tags: awk curl

Up
Down

random xkcd comic as xml

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

wget -q http://dynamic.xkcd.com/comic/random/ -O-| sed -n '/<img src="http:\/\/imgs.xkcd.com\/comics/{s/.*$http:.*$" t.*/\1/;p}' | awk '{system ("wget -q " $1 " -O- | display -title $(basename " $1") -write /tmp/$(basename " $1")");}'

2009-12-09 13:41:25

User: laugg

Functions: awk sed wget

Tags: sed awk wget comic

Up
Down

View a random xkcd comic

Only need to install Image Magick package.

Display a xkcd comic with its title and save it in /tmp directory

If you prefer to view the newest xkcd, use this command:

wget -q http://xkcd.com/ -O-| sed -n '/<img src="http:\/\/imgs.xkcd.com\/comics/{s/.*\(http:.*\)" t.*/\1/;p}' | awk '{system ("wget -q " $1 " -O- | display -title $(basename " $1") -write /tmp/$(basename " $1")");}'

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

traceroute 2>/dev/null -n google.com | awk '/^ *1/{print $2;exit}'

2009-12-08 21:44:45

User: sputnick

Functions: awk traceroute

Tags: Arp

Up
Down

Router discovery

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

ps ax| awk '/[h]ttpd/{print $1}'| xargs kill -9

2009-12-07 09:53:18

User: r00t4u

Functions: awk kill ps xargs

-2

Up
Down

Killing multiplpe process for one program like apache, wget, postfix etc.

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

for i in `mysqladmin -h x.x.x.x --user=root -pXXXX processlist | grep <<username>>| grep <<Locked>>| awk {'print $2'}` do mysqladmin -h x.x.x.x --user=root -pXXX kill $i; done;

2009-12-06 05:46:48

User: r00t4u

Functions: awk grep kill

Up
Down

Kill multiple Locked connection by a single user in MYSQL DB

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

‹ First < 34 35 36 37 38 > Last ›