This is my first post, but I have already received a lot of help from the forums in the past. Thanks!
I've searched the forums and my question is very similar to an earlier post entitled "Printing highest value from one column", which I am apparently not yet allowed to post a link to (only 4 more posts until I can spam!!).
My problem is that I have more columns, and want the whole line printed. For the example:
Line ID Sort Extra Extra2
1 A 3 4 3
2 A 1 2 1
3 A 2 3 2
4 A 1 1 1
5 B 1 1 1
6 B 1 2 1
7 B 3 3 3
8 C 1 1 1
9 D 3 1 3
10 E 3 1 3
11 E 3 2 3
I want to print one line for every unique ID value that has the highest value in Sort. Giving the output:
Line ID Sort Extra Extra2
1 A 3 4 3
7 B 3 3 3
8 C 1 1 1
9 D 3 1 3
11 E 3 2 3
If the sort value is equal for any given ID, I don't really care which is returned as in ID=E.
Franklin52's answer (modified for my data) in the previous post mentioned was close:
Code:
awk 'a[$2] < $3{a[$2]=$3} END{for(i in a){print i, a[i]}}' file
However, I can't seem to get it to print the whole line. Please let me know what I am missing!
Hello folks,
Please guide me i have a file file.txt that have below text.
PETER JOHN peter@example.com
John Col john@example.com
Sara Paul sara@example.com
I just want to extract only email address list. (5 Replies)
I have a .csv file which is seperated with (;)
inputfile
---------
ZZZZ;AAAA;BBB;CCCC;DDD;EEE;
YYYY;BBBB;CCC;DDDD;EEE;FFF;
...
...
reading file line by line till end of file.
while reading each line output format should be .
i need to print only specific columns let say 5th... (2 Replies)
Hi everyone,
This is my first post, but I have already received a lot of help from the forums in the past. Thanks!
I've searched the forums and my question is very similar to an earlier post entitled "Printing highest value from one column", which I am apparently not yet allowed to post a... (3 Replies)
Hello everyone,
I am writing a script to process data from the ATP world tour.
I have a file which contains:
t=540 y=2011 r=1 p=N409
t=540 y=2011 r=2 p=N409
t=540 y=2011 r=3 p=N409
t=540 y=2011 r=4 p=N409
t=520 y=2011 r=1 p=N409
t=520 y=2011 r=2 p=N409
t=520 y=2011 r=3 p=N409
The... (4 Replies)
I have a file like:
I would like to find lines lines with duplicate values in column 1, and retain only one based on two conditions: 1) keep line with highest value in column 3, 2) if column 3 values are equal, retain the line with the highest value in column 4.
Desired output:
I was able to... (3 Replies)
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
Hi,
I have some data like below:
John 254
Chris 254
Matt 123
Abe 123
Raj 487
Moh 487
How can i print it using awk to have:
254 John,Chris
123 Matt,Abe
487 Raj,Moh
Thanks. (4 Replies)
Hi, I have a little issue right now.
I have a file with 4 columns
test0000002,10030010330,c_,218
test0000002,10030010330,d_,202
test0000002,10030010330,b_,193
test0000002,10030010020,c_,178
test0000002,10030010020,b_,170
test0000002,10030010330,a_,166
test0000002,10030010020,a_,151... (2 Replies)
Hi, I have a little issue right now.
I have a file with 4 columns
test0000002,10030010330,c_,218
test0000002,10030010330,d_,202
test0000002,10030010330,b_,193
test0000002,10030010020,c_,178
test0000002,10030010020,b_,170
test0000002,10030010330,a_,166
test0000002,10030010020,a_,151... (3 Replies)
grepping on a value but then want to print only those lines that have the highest value in the 4th column
log text text R59FJ
log text text R63FT
log text text R60JX
log1 text text R63EA
log1 text text R60JX desired output
log text text R63FT
log1 text text R63EAtried this but not getting... (2 Replies)
Discussion started by: jimmyf
2 Replies
LEARN ABOUT DEBIAN
tracetopends
TRACETOPENDS(1) User Commands TRACETOPENDS(1)NAME
tracetopends - reports the endpoints that are responsible for the most traffic in a trace
SYNOPSIS
tracetopends [ -f bpf ] [ -A addrtype ] [ -s ] [ -d ] [ -b ] [ -a ] [ -p ] [ -n topcount ] inputuri [inputuri ...]
DESCRIPTION
tracetopends reports the number of bytes and packets sent and received by the busiest endpoints observed in the input trace(s).
-f bpf filter
Output only packets that match tcpdump style bpf filter.
-n top count
Report the top N endpoints (defaults to 10).
-A address type
Specifies how an endpoint should be defined. Suitable options are "mac", "v4" and "v6" which will report endpoint stats for each
observed MAC address, IPv4 address and IPv6 address respectively.
-s Sort endpoints based on the amount of outgoing traffic (will cancel any previous -d option. This is on by default.
-d Sort endpoints based on the amount of incoming traffic (will cancel any previous -s option.
-b Sort endpoints based on the amount of IP traffic (will cancel any previous -a or -p options. This is on by default.
-a Sort endpoints based on the amount of application layer traffic (will cancel any previous -b or -p options.
-p Sort endpoints based on the amount of packets (will cancel any previous -b or -a options.
OUTPUT
Output is written to stdout in columns separated by blank space.
The columns are (in order):
* Endpoint address
* Time last observed
* Packets originating from the endpoint
* Bytes originating from the endpoint (IP header onwards)
* Payload originating from the endpoint (post transport header)
* Packets sent to the endpoint
* Bytes sent to the endpoint (IP header onwards)
* Payload sent to the endpoint (post transport header)
EXAMPLES
Find the IPv4 addresses that are sending the most traffic.
tracetopends -A v4 -b -s erf:trace.erf.gz
LINKS
More details about tracetopends (and libtrace) can be found at http://www.wand.net.nz/trac/libtrace/wiki/UserDocumentation
SEE ALSO libtrace(3), tracemerge(1), tracefilter(1), traceconvert(1), tracesplit_dir(1), tracereport(1), tracertstats(1), tracestats(1), tracepkt-
dump(1), traceanon(1), tracesummary(1), tracereplay(1), tracediff(1), traceends(1)AUTHORS
Shane Alcock <salcock@cs.waikato.ac.nz>
tracetopends (libtrace) September 2011 TRACETOPENDS(1)