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:
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
dbix::class::helper::row::storagevalues
DBIx::Class::Helper::Row::StorageValues(3pm) User Contributed Perl Documentation DBIx::Class::Helper::Row::StorageValues(3pm)NAME
DBIx::Class::Helper::Row::StorageValues - Keep track of stored vs in-memory row values
VERSION
version 2.013002
SYNOPSIS
package MyApp::Schema::Result::BlogPost;
use parent 'DBIx::Class::Core';
__PACKAGE__->load_components(qw(Helper::Row::StorageValues));
__PACKAGE__->table('BlogPost');
__PACKAGE__->add_columns(
id => {
data_type => 'integer',
is_auto_increment => 1,
},
title => {
data_type => 'varchar',
length => 32,
keep_storage_value => 1,
},
body => {
data_type => 'text',
},
);
1;
# elsewhere:
my $post = $blog_rs->create({
title => 'Components for fun and profit',
body => '...',
});
$post->title('Components for fun');
warn sprintf 'Changing title from %s to %s',
$post->storage_value('title'), $post->title;
$post->update;
DESCRIPTION
This component keeps track of the value for a given column in the database. If you change the column's value and do not call "update", the
"storage_value" will be different; once "update" is called the "storage_value" will be set to the value of the accessor. Note that the
fact that it uses the accessor is an important distinction. If you are using DBIx::Class::FilterColumn or DBIx::Class::InflateColumn it
will get the non-storage or inflated values, respectively.
METHODS
_has_storage_value
$self->_has_storage_value('colname')
returns true if we should store the storage value from the database. Override this if you'd like to enable storage on all integers or
something like that:
sub _has_storage_value {
my ( $self, $column ) = @_;
my $info = $self->column_info($column);
return defined $info->{data_type} && $info->{data_type} eq 'integer';
}
storage_value_columns
$self->storage_value_columns
returns a list of columns to store
get_storage_value
$self->get_storage_value('colname')
returns the value for that column which is in storage
AUTHOR
Arthur Axel "fREW" Schmidt <frioux+cpan@gmail.com>
COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Arthur Axel "fREW" Schmidt.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-06-18 DBIx::Class::Helper::Row::StorageValues(3pm)