Text Parser

karthikn7974 · 04-22-2008, 01:18 AM

I am having a text file as follows

say server.txt

Code:

Date        Time          server      ip                error code
--------------------------------------------------------------------------
02/21/2008   18:10:14   server1  xxx.xxx.xxx.xxx    6
02/21/2008   08:10:14   server2  xxx.xxx.xxx.xxx    196
03/21/2008   21:10:14   server8  xxx.xxx.xxx.xxx    96
03/21/2008   12:10:14   server9  xxx.xxx.xxx.xxx    132
04/21/2008   06:10:14   server4  xxx.xxx.xxx.xxx    254
04/21/2008   18:10:14   server6  xxx.xxx.xxx.xxx    6

I need a script to write lines to new file which satisfy the below condition

if Date=02/21/2008 and server=server1 and error code=6 and ip=xxx.xxx.xxx.xxx then that line should be written to output.txt

Please let me know any script can satisfy all 4 condition strings in a line...

Thanks in advance

billymayday · 04-22-2008, 01:31 AM

How big is the file?

Not efficient or neat, but

cat server.txt | grep 02/21/2008 | grep server1 | grep "xxx.xxx.xxx.xxx 6" > outfile.txt

Edit - losing whitespaces - you would need the correct number of spaces between x and 6

Edit 2 or you could

cat server.txt | grep 02/21/2008 | grep "server1 xxx.xxx.xxx.xxx 6" > outfile.txt

karthikn7974 · 04-22-2008, 02:30 AM

Hi Bill,

Thanks for your info,

But my friend sent another script using awk which is working fine too, just to share with this LQ

Code:

awk '{
if($1=="02/21/2008" && $3=="server1" && $4=="xxx.xxx.xxx.xxx " && $5==6)
print
}' filename

Thanks