|
|
Sed command
08-26-2010
# ./justdoit 66.249.71.98 - - [22/Aug/2010:00:04:00 +0000] GET /ad-openx.php?out=js&d=mod-top-hdr-defer&z-i=24809&z-n=top-leaderboard&i-w=728&i-h=90&i-e=pi%3D45%26amp%3Btv%3Dkp-CT1-G%26amp%3Bpm_mode%3Dp&i-s=pgtp%3Dkeyword%26pi%3D45%26pe_id%3Dcarrot-cake%26tn%3Dnone%26tv%3Dkp-CT1-G HTTP/1.1 200 1020 67.162.10.216 - - [22/Aug/2010:01:00:00 +0000] GET /tracker.js.php?45aa01ed37b58d2a537b1ba12bb97fe2e5695a8c HTTP/1.1 200 2915 67.162.10.216 - - [22/Aug/2010:02:00:00 +0000] GET /tracker.js.php?45aa01ed37b58d2a537b1ba12bb97fe2e5695a8c HTTP/1.1 200 2882
## justdoit ##
#!/bin/bash
sort a.txt | while read -r l
do
cond=$(date +"%s" -d "`echo "$l" | awk '{print $4}' | sed 's/^.//;s/\// /g' | sed 's/\(.*\) \(.*\) [^:]*:\(.*\)/\2 \1 \3/'`")
xd=$(date +"%s" -d "Aug 21 06:00:00")
yd=$(date +"%s" -d "Aug 22 09:00:00")
if [ $cond -ge $xd ] && [ $cond -le $yd ] ; then
echo "$l"
fi
done
awk '
BEGIN{
m["Jan"]="01"
m["Feb"]="02"
m["Mar"]="03"
m["Apr"]="04"
m["May"]="05"
m["Jun"]="06"
m["Jul"]="07"
m["Aug"]="08"
m["Sep"]="09"
m["Oct"]="10"
m["Nov"]="11"
m["Dec"]="12"
start="20100821060000"
end="20100822090000"
}
{ split($4,a,":"); sub(/\[/,"",a[1]);split(a[1],b,"/")
t=b[3] m[b[2]] b[1] a[2] a[3] a[4];
if (t>start&&t<end) print
}' a.txt | sort
66.249.71.98 - - [22/Aug/2010:00:04:00 +0000] GET /ad-openx.php?out=js&d=mod-top-hdr-defer&z-i=24809&z-n=top-leaderboard&i-w=728&i-h=90&i-e=pi%3D45%26amp%3Btv%3Dkp-CT1-G%26amp%3Bpm_mode%3Dp&i-s=pgtp%3Dkeyword%26pi%3D45%26pe_id%3Dcarrot-cake%26tn%3Dnone%26tv%3Dkp-CT1-G HTTP/1.1 200 1020
67.162.10.216 - - [22/Aug/2010:01:00:00 +0000] GET /tracker.js.php?45aa01ed37b58d2a537b1ba12bb97fe2e5695a8c HTTP/1.1 200 2915
67.162.10.216 - - [22/Aug/2010:02:00:00 +0000] GET /tracker.js.php?45aa01ed37b58d2a537b1ba12bb97fe2e5695a8c HTTP/1.1 200 2882|
|
|
|