Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Text Parser

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Text Parser
# 1  
Old 04-22-2008
Question Text Parser
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
# 2  
Old 04-22-2008
Code:
awk '{
if($1=="02/21/2008" && $3=="server1" && $4=="xxx.xxx.xxx.xxx " && $5==6)
print
}' filename

# 3  
Old 04-22-2008
Question
There is no error in using your awk, but no result. i see only a blank file. can u give more details.
# 4  
Old 04-22-2008
Remove the extra space after the IP address ($4=="xxx.xxx.xxx.xxx " ) in the awk command.

It works perfectly fine.
# 5  
Old 04-22-2008
Question
This is wat i tried

Image
# 6  
Old 04-22-2008
this is the command i used
$ sh aaa.sh 02/21/2008 server1 xxx.xxx.xxx.xxx 6 input.txt
# 7  
Old 04-22-2008
Lightbulb
Hi ALL,

It Works fine Smilie.

thanks to all.
Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Making a parser

input 1..100km 112..403km 500..623km required output 1..51 112..162 500..550 (i.e 50kms added to the initial distance) (2 Replies)
Discussion started by: ANKIT ROY
2 Replies

2. Shell Programming and Scripting

Parser

Hi All, I am trying to create a parser to find out what cobol programs are being called by which JCL's. I need to search recursively until the main cobol program is found being called by a JCL. I tried to create a script but I am not able to generalize it. Can someone please help. ... (1 Reply)
Discussion started by: nua7
1 Replies

3. Shell Programming and Scripting

SQL Parser

Hi, I have been assigned a task to migrate few thousands of sql scripts to a different db format. there could be sub queries and complex joins. there would be functions that needs to be replaced from a given list to another values. this should also parse the sub\inline queries. Can you please... (1 Reply)
Discussion started by: hitmansilentass
1 Replies

4. Shell Programming and Scripting

File Parser

Hi need help parsing a file. I have tag fields and values in a file with delimiter |. sample records from the file listed below 8=value|9=value|35=value|49=value|56=value|34=value|50=value|48=value|10=value 8=value|9=value|35=value|49=value|56=value|34=value|51=value|48=value|10=value... (2 Replies)
Discussion started by: subramanian
2 Replies

5. Programming

Parser

Hi Everyone I have an out put of multiple lines which I would like to parse and retrieve certain info from it. The output consists of multiple sections that starts with the line Client: and ends with STL tag: each section separated by an empty line. So basically somehting like Client: ... (10 Replies)
Discussion started by: bombcan1
10 Replies

6. Shell Programming and Scripting

Parser with sed

Hi, I have this variable: <a href="http://www.rtve.es/mediateca/videos/20100916/video-calamares-rellenos-salsa-pimientos-garbanzos-16-09-10/878586.shtml">V�deo: Calamares rellenos con salsa de pimientos y ...</a> I would like to have: ... (7 Replies)
Discussion started by: mierdatuti
7 Replies

7. Shell Programming and Scripting

Incremental log parser

I have log file that is incremented every second and is rather big. I need monitor error in this file. I do not want to parse it all every time. I want parse it first time then remember last position (as byte for example) All consequent parsing I want to start from last saved position to the... (3 Replies)
Discussion started by: Narcom
3 Replies

8. Shell Programming and Scripting

need a text parser

i need a simple text parser which can parse a data file created by a softwre so that i can export it to my mysqldb,, datafile created as one record per line with different number of fields. e.g datafile contains following. a=1, b=3, c=4 a=1, c=55, d=abcd a=5, b=hello, c=99, d=help now i... (12 Replies)
Discussion started by: sfaizan
12 Replies

9. Shell Programming and Scripting

Help with an (easy) parser

Hello, i'm workig with a file with structural information about biological macromolecules (proteins etc). In a certain file, the info is structured like this @<TRIPOS>MOLECULE blah 1 blah 2 blah 3 @<TRIPOS>MOLECULE foo 1 foo 2 foo 3 @<TRIPOS>MOLECULE mmm 1 mmm 2 mmm 3 I would... (7 Replies)
Discussion started by: aristegui
7 Replies

10. Shell Programming and Scripting

string parser

I am new to scripting I want to parse a string in a loop eg A:B:C:D E:F:G:H and put them in different variable attr1 = A attr2 = B attr3 = C attr4 = D . . /* do processing with attr1, attr2, attr3 and attr4 */ then go to next line E:F:G:H and again assign... (8 Replies)
Discussion started by: flextronics
8 Replies
Login or Register to Ask a Question