awk code

extract table names from sql log file

grep "from " /var/log/mysql/mysqld.log | awk -Ffrom '{print $2}' | awk '{print $1}' | cat > /home/shantanu/testing.txt

to unix awk grep cat sql dump by shantanuo on Oct 12, 2007

Parse Exim log file with SpamAssassin score

grep '\[Spam score: [1-9]' /var/log/exim/main.log | awk '{print $3}' | xargs -t -i grep {} /var/log/exim/main.log > /var/log/exim/spam_score.log

grep 'reporter\.pl' /var/log/exim/main.log | awk '{print $3}' | xargs -t -i grep {} /var/log/exim/main.log > /var/log/exim/spam_reporter.pl.log

to awk xargs grep parse exim log files by Wallace on Sep 29, 2007

FInd slow actions in a Rails app

# Show a list of actions sorted by time taken. Useful for finding slow actions.
cat log/development.log | awk '/Completed/ { print "[" $3 "] - " $0 }' | sort -nr

to rails shell awk performance by sikelianos on Aug 21, 2007 2 Comments

See your most used shell commands

Found here.

history | awk '{print $2}' | awk 'BEGIN {FS="|"}{print $1}' | sort | uniq -c | sort -n | tail | sort -nr

to linux unix bash shell awk by peter on Jul 02, 2007 1 Comments

MySQL Database Size

mysql -uroot -D sfcnet_development -e "show table status\G"| egrep "(Index|Data)_length" | awk 'BEGIN { rsum = 0 } { rsum += $2 } END { print rsum }'

to cli mysql shell awk egrep by willcodeforfoo on Jun 08, 2007

HTML Table to CSV in AWK

Here's a simple AWK script to try to parse an HTML table into a comma seperated file
from http://euri.ca/blog/category/awk/

BEGIN {s=""; FS="n"}
/<td/ { gsub(/<[^>]*>/, ""); s=(s ", " $1);}
/<tr|<TR/ { print s; s="" }

And then you execute it (on windows) as: gawk -f 1.awk *.jsp > whatever.csv

to awk by jivechicken on Apr 20, 2007

Sort file by length of lines

cat $@ | awk '{ print length, $0 }' | sort -n | awk '{$1=""; print $0}'

to shell awk line sort length by AlpT on Jan 13, 2007

processing columns

print the first column, delimited by space

nawk -Fc '{print $1}' test.txt

print the second column, delimited by :

nawk -F: '{print $2}' test.txt

to linux bash awk columns proceessing by nevadalife on Sep 23, 2006

OSX Restart Lookupd

sudo kill -HUP `ps -ax | grep lookupd | grep sbin | awk '/(\d+).*/ { print $1 }'`

to osx bash shell awk lookupd by phlipper on Sep 21, 2006

Clearing out a bunch of spam with spoofed emails that were bounced back to some poor guy with a catchall email

We don't really want to delete them all just in case.

cd /usr/local/scratch/
mkdir junk
find /var/spool/postfix -exec grep "somediscernible-feature.com" '{}' \; | awk '{print($3)}' | xargs -J X mv X ./junk/

The "find" produces

Binary file /var/spool/postfix/active/D/D8832E38 matches
Binary file /var/spool/postfix/active/D/D78EC1C72 matches
Binary file /var/spool/postfix/active/D/D593D279D matches
Binary file /var/spool/postfix/active/D/D0EB32833 matches

The awk

/var/spool/postfix/active/D/D8832E38
/var/spool/postfix/active/D/D78EC1C72
/var/spool/postfix/active/D/D593D279D
/var/spool/postfix/active/D/D0EB32833

And then the mv, moves it.

to find awk xargs postfix email spam spool by jason on Apr 23, 2005

Search DZone Snippets

Popular @ dzone.com

Related Tags

Never been to DZone Snippets before?