Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

awk script to find repeated IP adress from trace file (.tr)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers awk script to find repeated IP adress from trace file (.tr)
# 8  
Old 03-01-2017
Enter the script in post#6 on the command line, replacing "file" with your file name.
# 9  
Old 03-01-2017
thanks,

filename: pm-ex.awk

awf -f pm-ex.awk pm-ex.tr

Code:
awk '
        {
         IX = $29 " > " $31
         sub (/\)/, _, IX)
         CNT[IX]++
         MIN[IX] = $2<MIN[IX] || !MIN[IX]?$2:MIN[IX]
         MAX[IX] = $2>MAX[IX]            ?$2:MAX[IX]
        }
END     {for (c in CNT) printf "%20s %3d %9.5f %9.5f\n", c, CNT[c], MIN[c], MAX[c]
        }

# 10  
Old 03-01-2017
Quote:
Originally Posted by Nipa
filename: pm-ex.awk

awf -f pm-ex.awk pm-ex.tr
Sigh....

Put the following (ONLY the following) into file pm-ex.awk:

Code:
        {
         IX = $29 " > " $31
         sub (/\)/, _, IX)
         CNT[IX]++
         MIN[IX] = $2<MIN[IX] || !MIN[IX]?$2:MIN[IX]
         MAX[IX] = $2>MAX[IX]            ?$2:MAX[IX]
        }
END     {for (c in CNT) printf "%20s %3d %9.5f %9.5f\n", c, CNT[c], MIN[c], MAX[c]
        }

Only then repeat your command.

Don gave you a COMMAND you could paste into the command line, only replacing "file" with the name of your input file. You changed what he gave you without understanding how awk works and what it expects where. You might want to consider playing around with these things and altering them only after you have got the slightest idea about which rules it follows.

I hope this helps.

bakunin
# 11  
Old 03-02-2017
cheers..

thanx a lot programmers!!
# 12  
Old 03-02-2017
Do you regard that code snippet as the final solution to your problem in post#1? If not, please post the final code for completeness and closure of the thread.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk script to find data in three file and perform replace operation

Have three files. Any other approach with regards to file concatenation or splitting, etc is appreciated If column55(billngtype) of file1 contains YMNC or YPBC then pick the value of column13(documentnumber). Now find this documentnumber in column1(Billdoc) of file2 and grep the corresponding... (4 Replies)
Discussion started by: as7951
4 Replies

2. Shell Programming and Scripting

Find repeated word and take sum of the second field to it ,for all the repeated words in awk

Hi below is the input file, i need to find repeated words and sum up the values of it which is second field from the repeated work.Im trying but getting no where close to it.Kindly give me a hint on how to go about it Input fruits,apple,20,fruits,mango,20,veg,carrot,12,veg,raddish,30... (11 Replies)
Discussion started by: 100bees
11 Replies

3. Shell Programming and Scripting

awk based script to find the average of all the columns in a data file

Hi All, I need the modification for the below mentioned code (found in one more post https://www.unix.com/shell-programming-scripting/27161-script-generate-average-values.html) to find the average values for all the columns(but for a specific rows) and print the averages side by side. I have... (4 Replies)
Discussion started by: ks_reddy
4 Replies

4. Shell Programming and Scripting

Awk based script to find the median of all individual columns in a data file

Hi All, I have some data like below. Step1,Param1,Param2,Param3 1,2,3,4 2,3,4,5 2,4,5,6 3,0,1,2 3,0,0,0 3,2,1,3 ........ so on Where I need to find the median(arithmetic) of each column from Param1...to..Param3 for each set of Step1 values. (Sort each specific column, if the... (5 Replies)
Discussion started by: ks_reddy
5 Replies

5. Shell Programming and Scripting

sort file with email adress

Hi All, I have a file which is "|" pipe delimited. The file has 3 fields. the last field contains email ids which has different host names. I want to sort the file based on host name, which is in 3rd filed and needs to create a file for each host. For example, if out of 1000 records, 10... (6 Replies)
Discussion started by: ace_friends22
6 Replies

6. Shell Programming and Scripting

How to find repeated string in a text file

I have a text file where I need to find the string = ST*850* This string is repetaed several times in the file, so I need to know how many times it appears in the file, this is the text files: ISA*00* *00* *08*925485USNR *ZZ*IMSALADDERSP... (13 Replies)
Discussion started by: cucosss
13 Replies

7. Shell Programming and Scripting

Trying to get an IP adress from a file

This is probably a real n00b question but i`m not able to figure it out. I have a folder of configuration files that contain IP-adresses. The line i`m interested in looks like this: IP_ADDRESS="123.123.123.1123" Some have muliple ip adresses, so the line will look like : ... (5 Replies)
Discussion started by: DaneV
5 Replies

8. Shell Programming and Scripting

To find the repeated name in subject

Hi, I am using a mail application, When I use to check with the command, I will get the outputs as q -s 6128175 (9, 9/6128175) Return-path: minka.bell@abcd.org From: "Minka Bell" <minka.bell@abcd.org> To: <dcrouch@xyz.org>, Subject: Open items with new PICT system Date: Wed,... (12 Replies)
Discussion started by: gsiva
12 Replies

9. Shell Programming and Scripting

To find the IP adress in the log file

Hi, I need to find out the repeated IP address from the apache log file from my box. I did try to come out with the script, but I could not grep out the repeated Ip Address from the error_logs and need to redirect to a file. Can you guys please help me out of this problem. Thanks in... (9 Replies)
Discussion started by: gsiva
9 Replies

10. UNIX for Dummies Questions & Answers

how to find a word repeated in a file

Hi everyone, I have a file in which a word is repeated more than one time and I want to know how many times it is repeated. ex: if i repeated word 'guru' in 10 lines I can get the o/p as: cat filename | grep -c 'guru'. How ever if the word is repeated more than one time, then how can I... (4 Replies)
Discussion started by: gurukottur
4 Replies
Login or Register to Ask a Question