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
gpiv_hdf2piv
GPIV_HDF2PIV(1) General Commands Manual GPIV_HDF2PIV(1)NAME
gpiv_hdf2piv - Converts HDF5 PIV-data to ASCII data.
SYNOPSIS
gpiv_hdf2piv [-e] [-h | --help] [-p | --print] [-v | --version] filename
DESCRIPTION
gpiv_hdf2piv converts a HDF5 formatted file filename.hdf, containing PIV-data, PIV derived data, like vorticities, strain etc to (ASCII
formatted) filename.piv., filename.vor, filename.sstr, filename.nstr and, eventually, image(s) to (PNG formatted) filename.png files. The
parameters that have been used for the analysis and post processing are written to filename.par
This program does not use the parameter resources from libgpiv. The parameters may be defined by the command line options as explained
below.
Options-e Exclude PIV data and data from post-processes. Only convert image data.
-h | --help
On-line help.
-p | --print
Prints parameters, command line options and input and output filenames to stdout. The output may be used as parameters of fasty for
future use by re-directing stdout to fasty.par.
-v | --version
Print version information on standard output, then exits successfully.
filename
Full input file name, hdf formatted (including .hdf extension)
SEE ALSO
gpivtools
AUTHOR
Gerber Van der Graaf
19 Januari 2005 GPIV_HDF2PIV(1)
06-28-2011
).