I had managed to twist the close Franklin52 answer into:
which seems to get the job done, but it was 3AM when I pieced this together and decided sleep was important.
Although both seem to work, I used your solution, primarily because I THINK a can understand what it is doing (unlike my solution).
So you are printing the uniq values in the column of interest and making them an array. You then search (grep) my file for lines containing each value in the array. Sort each value in reverse numerical order in the column I want the highest value in (k3). Then you print the first line (highest column 3 value) for each individual in the array. Then you are done.
Does that sound like a correct explanation? Just trying to understand what I am doing, instead of just doing what I am doing! Regardless, it worked perfectly! Thanks again.
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... (1 Reply)
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
rakudo
rakudo(1) User Contributed Perl Documentation rakudo(1)NAME
perl6 - Rakudo Perl 6 Compiler
SYNOPSIS
perl6 [switches] [--] [programfile] [arguments]
DESCRIPTION
With no arguments, enters a REPL. With a "[programfile]" or the "-e" option, compiles the given program and by default also executes the
compiled code.
-c check syntax only (runs BEGIN and CHECK blocks)
-e program one line of program
-h, --help display this help text
-n run program once for each line of input
-p same as -n, but also print $_ at the end of lines
--target=[stage] specify compilation stage to emit
-t, --trace=[flags] enable trace flags, see 'parrot --help-debug'
--encoding=[mode] specify string encoding mode
-o, --output=[name] specify name of output file
-v, --version display version information
--stagestats display time spent in the compilation stages
--ll-backtrace display a low level backtrace on errors
Note that only boolean single-letter options may be bundled
Supported stages for --target are:
parse past post pir evalpmc
where
parse = a representation of the parse tree
past = an intermediate format representing the parrot abstract syntax tree
post = an intermediate format representing the parrot opcode syntax tree
pir = the parrot intermediate representation
PARROT OPTIONS
To specify options to the underlying parrot VM, you must explicitly run parrot; you cannot specify these options by using the "perl6"
executable.
parrot [parrot switches] perl6.pbc [switches] [--] [programfile] [arguments]
See "parrot --help" for a list of valid parrot options.
AUTHORS
Written by the Rakudo contributors, see the CREDITS file.
This manual page was written by Reini Urban, Moritz Lenz and the Rakudo contributors.
perl v5.14.2 2012-01-22 rakudo(1)