Commands using awk sorted by votes

Commands using awk (1,418)

sorted by

Get a text on a position on the file and store in a variable
This is sample output - yours may be different.
-1

TIMEUNIT=$(awk '/timescale/{print NR}' a)

arcege · 2009-10-28 12:12:37 3
Get column names in MySQL

Useful when you need to write e.g. an INSERT for a table with a large number of columns. This command will retrieve the column names and comma-separate them ready for INSERT INTO(...), removing the last comma.
This is sample output - yours may be different.
-1

mysql -u <user> --password=<password> -e "SHOW COLUMNS FROM <table>" <database> | awk '{print $1}' | tr "\n" "," | sed 's/,$//g'

maxmanders · 2009-10-29 13:42:17 3
force change password for all user
This is sample output - yours may be different.
-1

for i in `cat /etc/passwd | awk -F : '{ print $1 }';`; do passwd -e $i; done

irraz · 2009-11-11 13:01:22 3
kalarm 1 per minute simplest e-mail beacom for Geovision surveillance DVR

I have a custmer's Geovision DVR installed on a closed proxi (only logme-in reaches it). I have to check for reliability but logmein hangs and is too slow a process I made the Geovision software send e-mail every minute to the www.spam.la site. All this script does is to retrieve the e-mail header from spam.la ( no login!), filtering sender, stopping at the first occurrence of the word "secs" ( the age of the last e-mail ). The result is the age of the sender's last e-mail, tiny published on top of my screen once a minute. I can refresh www.spam.la via web browser, but have other things to do. I use it inside Kalarm ( kde task schedule ) set to 1 minute repeat. It can be done without kalarm, using Watch outside the script. Try it out now using my account = geo1 ( change sender by geo1 in this script) Needs curl , osd-bin
This is sample output - yours may be different.
-1

curl http://www.spam.la/?f=sender | grep secs| awk '{print; exit}' | osd_cat -i 40 -d 30 -l 2

m33600 · 2009-11-12 21:33:06 5
Match a URL

don't have to be that complicated
This is sample output - yours may be different.
-1

cho "(Something like http://foo.com/blah_blah)" | awk '{for(i=1;i<=NF;i++){if($i~/^(http|ftp):\/\//)print $i}}'

unixmonkey7109 · 2009-11-28 03:31:41 6
View the newest xkcd comic.

Same thing just a different way to get there. You will need lynx
This is sample output - yours may be different.
-1

lynx --dump --source http://www.xkcd.com | grep `lynx --dump http://www.xkcd.com | egrep '(png|jpg)'` | grep title | cut -d = -f2,3 | cut -d '"' -f2,4 | sed -e 's/"/|/g' | awk -F"|" ' { system("display " $1);system("echo "$2); } '

solarislackware · 2009-12-03 18:53:57 3
Return IP Address

Tested on Solaris.
This is sample output - yours may be different.
-1

/usr/sbin/ifconfig -a|awk -F" " 'NR==4{print $2}'

elZaphod · 2009-12-04 18:41:29 4
Show Network IP and Subnet

same thing as the other
This is sample output - yours may be different.
-1

ipcalc $(ifconfig eth0 | grep "inet addr:" | cut -d':' -f2,4 | sed 's/.+Bcast:/\//g') | awk '/Network/ { print $2 } '

solarislackware · 2009-12-05 15:00:32 3
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). Show Sample Output
This is sample output - yours may be different.
```
$ awk '{if (NR % 3 == 1) print $0}' blah1
1
4
7

$ awk '{if (NR % 3 == 2) print $0}' blah1
2
5
8

$ awk '{if (NR % 3 == 0) print $0}' blah1
3
6
9
```
-1

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

oshazard · 2010-01-08 04:20:06 4
open new tab without in gnome-terminal

open a new tab in active gnome-terminal instance needs sudo apt-get install xdotool and sudo apt-get install wmctrl
This is sample output - yours may be different.
-1

WID=xprop -root | grep "_NET_ACTIVE_WINDOW(WINDOW)"| awk '{print $5}' xdotool windowfocus $WID xdotool key ctrl+shift+t wmctrl -i -a $WID

drunkcoder · 2010-03-22 08:34:24 7
output one file per line

Problem: you want to output one line per file. you can't just 'tr -d' because you want one line per file and you don't want to use a loop. Solution: use awk to print each line without the record separator and a newline after each file. Show Sample Output
This is sample output - yours may be different.
```
$ cat a.txt
line1
line2
line3
$ cat b.txt
foo
bar
baz
$ awk 'BEGIN{ORS=""}NR!=1&&FNR==1{print "\n"}{print}END{print "\n"}' a.txt b.txt
line1line2line3
foobarbaz
```
-1

awk 'BEGIN{ORS=""}NR!=1&&FNR==1{print "\n"}{print}END{print "\n"}' *.txt

recursiverse · 2010-05-24 19:22:35 8
Kill processes hogging up CPU (Flash after resume)

I found Flash eating one of my CPUs after resume, the command above will help with that. For optional kicks you can put it into a script in /etc/pm/sleep.d/ (aspect in #swhack wrote this for me)
This is sample output - yours may be different.
-1

top -bn 1 | awk '{if($1 ~ /^[0-9]+$/ && $9 > 97) {print $1;exit}}'|xargs kill

chx · 2010-06-02 13:51:40 5
calculate the total size of files in specified directory (in Megabytes)

the command will not include hidden files Show Sample Output
This is sample output - yours may be different.
```
$ls -l | awk 'BEGIN { SUM=0 } { SUM+=$5 } END { print SUM/1024/1024"M" }'
11.35349M
```
-1

ls -l directory | awk 'BEGIN { SUM=0 } { SUM+=$5 } END { print SUM/1024/1024"M" }'

emacs · 2010-06-04 01:51:04 3
List of commands you use most often

This alternative cleans HISTTIMEFORMAT environment variable and calls gnuplot just after /tmp/cmds is closed, to avoid some errors.
This is sample output - yours may be different.
-1

HISTTIMEFORMAT='' history | awk '{a[$2]++}END{for(i in a){print a[i] " " i}}' | sort -rn | head > /tmp/cmds ; gnuplot -persist <<<'plot "/tmp/cmds" using 1:xticlabels(2) with boxes'

narcelio · 2010-06-17 17:38:16 3
Quickly check a device in a LVM volume group against multipath

This is an easy way to quickly get a status for a device in multipath on SLES systems, as long as the server is configured based on Novell's standards, where multipathed disks are referred to by /dev/disk/by-... tree. Make sure to replace name_of_vg with your Volume Group name.
This is sample output - yours may be different.
-1

pvscan | awk '/name_of_vg/ {print $2}' | sed 's/[-|/|]/ /g' | cut -d " " -f7

slashdot · 2010-06-22 16:34:42 3

print statistics about users' connect time

'ac' is included in the package 'acct', which is described as "The GNU Accounting utilities for process and login accounting". Other interesting flags are: * print statistics for a specified user ac -d username * print statistics for all the users ac -p With my command, the output is also printed in a sexagesimal, more readable, style. Show Sample Output

-1

ac -d | awk '{h=int($NF); m=($NF-h)*60; s=int((m-int(m))*60); m=int(m); print $0" = "h"h "m"m "s"s "}'

karpoke · 2010-06-24 08:08:41 7

Delete the \n character at the end of file
This is sample output - yours may be different.
-1

awk 'BEGIN { ARGV[ARGC++]=ARGV[ARGC-1] } NR!=FNR { if(num==0) num=NR-1; if(FNR<num) {print} else { ORS=""; print } } ' abc1.txt > abc2.txt

kevintse · 2010-06-26 13:08:33 5
Find default gateway

Find your default gateway and print it directly output. http://www.bayner.com/ kerim@bayner.com Show Sample Output
This is sample output - yours may be different.
```
192.168.1.1
```
-1

ip route show | awk '$3 ~ /^[1-9]+/ {print $3;}'

kerim · 2010-08-08 23:57:23 3
Find default gateway
This is sample output - yours may be different.
-1

route -n | grep "^0\." | awk '{print "Gateway to the World: "$2", via "$NF""}'

bandie91 · 2010-08-09 11:55:37 26
Find default gateway

Tested on CentOS, Ubuntu, and MacOS.
This is sample output - yours may be different.
-1

netstat -rn | awk '/UG/{print $2}'

putnamhill · 2010-08-09 15:56:02 5
Restore individual table from mysqldump backup.

This will look through file and print the data in between the pattern matches. It's great for restoring tables from a mysqldump backup. You can then import it back into your database with: mysql -u <user> -h <host> <database> < restored_table.sql
This is sample output - yours may be different.
-1

awk '/Table structure for table .table01./,/Table structure for table .table02./{print}' <file> > restored_table.sql

din7 · 2010-08-09 18:23:13 3
View the newest xkcd comic.

Shorter version with curl and awk
This is sample output - yours may be different.
-1

eog `curl 'http://xkcd.com/' | awk -F "ng): |</h" '/embedding/{print $2}'`

dog · 2010-08-25 14:04:30 3
Switch to windows using gpicker

Require wmctrl and gpicker and an EWMH/NetWM compatible X Window Manager
This is sample output - yours may be different.
-1

wmctrl -i -a `wmctrl -l -x | gpicker -d "\n" -n "\n" - | awk '{print $1}'`

Iany · 2010-08-30 02:19:43 4
Sum up total size and count of all certain filename pattern/regex
This is sample output - yours may be different.
-1

find -regextype posix-egrep -regex ".*/[A-Z]{3}_201009[0-9]{2}.*" -printf "%f %s\n" | awk '{ SUM += $2;COUNT++ } END { print SUM/1024 " kb in " COUNT " files" }'

taintedkernel · 2010-09-21 15:41:45 3
Greets the user appropriately
This is sample output - yours may be different.
-1

echo -e "12 morning\n15 afternoon\n24 evening" | awk '{if ('`date +%H`' < $1) print "Good " $2}'

bazardeur · 2010-09-24 21:15:23 4
‹ First < 47 48 49 50 51 > 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

Terminal - Show directories in the PATH, one per line with sed and bash3.X `here string'

Banner Grabber

Produces a list of when your domains expire

Create a text file called domainlist.txt with a domain per line, then run the command above. All registries are a little different, so play around with the command. Should produce a list of domains and their expirations date. I am responsible for my companies domains and have a dozen or so myself, so this is a quick check if I overlooked any.

Quickly get summary of sizes for files and folders

Use this as a quick and simple alternative to the slightly verbose "du -s --max-depth=1"

Download all images from a 4chan thread

first grep all href images then sed the url part then wget

Get AWS temporary credentials ready to export based on a MFA virtual appliance

You might want to secure your AWS operations requiring to use a MFA token. But then to use API or tools, you need to pass credentials generated with a MFA token. This commands asks you for the MFA code and retrieves these credentials using AWS Cli. To print the exports, you can use: `awk '{ print "export AWS_ACCESS_KEY_ID=\"" $1 "\"\n" "export AWS_SECRET_ACCESS_KEY=\"" $2 "\"\n" "export AWS_SESSION_TOKEN=\"" $3 "\"" }'` You must adapt the command line to include: * $MFA_IDis ARN of the virtual MFA or serial number of the physical one * TTL for the credentials

List your installed Chromium extensions (with url to each page)

Gives you a list for all installed chrome (chromium) extensions with URL to the page of the extension. With this you can easy add a new Bookmark folder called "extensions" add every URL to that folder, so it will be synced and you can access the names from every computer you are logged in. ------------------------------------------------------------------------------------------------------------------ Only tested with chromium, for chrome you maybe have to change the find $PATH.

Batch rename extension of all files in a folder, in the example from .txt to .md

Create a nifty overview of the hardware in your computer

After the command is done, open the html file in a browser

Generate a random password 30 characters long

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