d={}
for line in open("file"):
line=line.strip().split(" ||| ")
d.setdefault(line[0],[])
d[line[0]].append(line[-1])
for i,j in d.iteritems():
for item in sorted(j,lambda x,y: int(y)-int(x))[:3]:
print "%s ||| %s" %(i,item)
So, I need to do some summing. I have an Apache log file with the following as a typical line:
127.0.0.1 - frank "GET /apache_pb.gif HTTP/1.0" 200 2326
Now, what I'd like to do is a per-minute sum. So, I can have awk tell me the individual minutes, preserving the dates(since this is a... (7 Replies)
hi
i have file as below , i want to add duplicate records like bell_bb to one record with valuve as 15 ( addition of both )
any oneline awk script to achive this ?
header 0
CAMPAIGN_NAME 1
Bell_BB 14
Bell_MONTHLY 803
SOLO_UNBEATABLE 644
Bell_BB 1
Bell_MONTHLY 25
SOLO_UNBEATABLE... (4 Replies)
Please help me to find out maximum value of a field based on grouping of other fields, as we do in SQL.
Like in SQL if we are having below records :
Client_Name Associate_Name Date1 Value
C1111 A1111 2012-01-17 10
C1111 A1111 ... (1 Reply)
Hi All,
i have a file like
col1 col2 col3
13 24 NA
12 13 14
11 12 13
14 22 NA
18 26 NA
in this file if i found "NA" other values in the line are also replace by NA
Could you help me! (7 Replies)
In the tab-delimeted input file below I am trying to use awk to update the value in $2 if TYPE=ins in bold, by adding the value of
HRUN= in italics. In the below since in line 1 TYPE=ins the 117282541 value in $2 has 6 added because that is the value of HRUN=.
Hopefully the awk is a start but I... (2 Replies)
I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines.
If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line... (3 Replies)
For some reason I am having difficulty performing what should be a fairly easy task. I would like to print lines of a file that have a unique value in the first field. For example, I have a large data-set with the following excerpt:
PS003,001 MZMWR/ L-DWD// *
PS003,001... (4 Replies)
Im looking for a way to average the values in field 14 (when field 2 is equal to 2016) and fields 3 and 4 (when field 2 is equal to 2017).
Any help is appreciated.
001001 2016 33.22 38.19 48.07 51.75 59.77 67.68 70.86 72.21 66.92 53.67 42.31 40.15
001001 2017 ... (10 Replies)
Hi,
So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple... (15 Replies)
Discussion started by: cotilloe
15 Replies
LEARN ABOUT DEBIAN
jifty::action::record::search
Jifty::Action::Record::Search(3pm) User Contributed Perl Documentation Jifty::Action::Record::Search(3pm)NAME
Jifty::Action::Record::Search - Automagic search action
DESCRIPTION
The class is a base class for Jifty::Actions that serve to provide an interface to general searches through Jifty::Record objects. To use
it, subclass it and override the "record_class" method to return the fully qualified name of the model to do searches over.
METHODS
arguments
Remove validators from arguments, as well as ``mandatory'' restrictions. Remove any arguments that render as password fields, or refer to
collections.
Generate additional search arguments for each field based on the following criteria:
"text", "char" or "varchar" fields
Create "field"_contains and "field"_lacks arguments
"date", or "timestamp" fields
Create "field"_before, "field"_after, "field"_since and "field"_until arguments.
"integer", "float", "double", "decimal" or "numeric" fields
Generate "field"_lt, "field"_gt, "field"_le and "field"_ge arguments, as well as a "field"_dwim field that accepts a prefixed
comparison operator in the search value, such as ">100" and "!100".
take_action
Return a collection with the result of the search specified by the given arguments.
We interpret a "undef" argument as SQL "NULL", and ignore empty or non-present arguments.
SEE ALSO
Jifty::Action::Record, Jifty::Collection
LICENSE
Jifty is Copyright 2005-2010 Best Practical Solutions, LLC. Jifty is distributed under the same terms as Perl itself.
perl v5.14.2 2010-12-10 Jifty::Action::Record::Search(3pm)