Hi,
I am new to this forum and new to awk.
I have a file that contains 2 columns.
Heres an example of what it looks like:
10 +
20 +
40 +
50 -
70 -
So the file is tab-delimited. What I want to do is add 10 to column 1 whenever column 2 is + and substract 10 from column 1... (1 Reply)
i have a file - it will be in sorted order on column 1
abc 0 1
abc 2 3
abc 3 5
def 1 7
def 0 1
--------
i'd like (awk maybe?) to get the results (any ideas)???
abc 5 9
def 1 8 (2 Replies)
Hi,
I have below as i/p file:
5ABC 36488989 K 000010000ASB BYTRES
5PQR 45757754 K 000200005KPC HGTRET
5ABC 36488989 K 000045000ASB HGTRET
5GTH 36488989 K 000200200ASB BYTRES
5FTU ... (2 Replies)
I have a following inputfile
MT,AP,CDM,TTML,MUM,GS,SUCC,3
MT,AP,CDM,TTSL,AP,GS,FAIL,9
MT,AP,CDM,RCom,MAH,GS,SUCC,3
MT,AP,CDM,RTL,HP,GS,SUCC,1
MT,AP,CDM,Uni,UPE,GS,SUCC,2
MT,AP,CDM,Uni,MUM,GS,SUCC,2
TTSL,AP,GS,MT,MAH,CDM,SUCC,20
TTML,AP,GS,MT,MAH,CDM,FAIL,10... (2 Replies)
i have file input
aaa ccc,45567,rterw,1
bbb dcs,564543,hjghgh,1
aaa ccc,454,rterw,6
i want to sum based on column 1
expected output
aaa ccc,7
bbb dcs,1 (4 Replies)
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Hello,
Below is a portion of a file I am working on:
2:15 3001 120
2:15 3001 26.25
2:15 3002 12.5
2:15 3002 15
9:45 3001 45
9:45 3001 45
9:45 3002 105
9:45 3005 180
9:45 3005 123.75
9:45 3005 15
I am trying to get the sum of column 3 for all repeated values of columns 1 and 2 (The... (6 Replies)
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
Hello,
I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically
I/p
c1,c2,c3,c4,c5
10,20,30,40,50
20,30,40,50,60
If i want to find sum only column c1, c3 and output it as c6,c7
O/p
c1,c2,c3,c4,c5,c6,c7
10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies
LEARN ABOUT DEBIAN
tm::index::match
TM::Index::Match(3pm) User Contributed Perl Documentation TM::Index::Match(3pm)NAME
TM::Index::Match - Topic Maps, Indexing support (match layer)
SYNOPSIS
# somehow get a map (any subclass of TM will do)
my $tm = ...
# one option: create a lazy index which learns as you go
use TM::Index::Match;
my $idx = new TM::Index::Match ($tm);
# for most operations which involve match_forall to be called
# reading and querying the map should be much faster
# learn about some statistics, what keys are most likely to be useful
my @optimized_keys = @{ $stats->{proposed_keys} };
# another option: create an eager index
my $idx = new TM::Index::Match ($tm, closed => 1);
# pre-populate it, use the proposed keys
$idx->populate (@optimized_keys);
# this may be a lengthy operation if the map is big
# but then the index is 'complete'
# query map now, should also be faster
# getting rid of an index explicitly
$idx->detach;
# cleaning an index
$idx->discard;
DESCRIPTION
This index implements a generic query cache which can capture all queries not handled by more specific indices. This class inherits
directly from TM::Index.
INTERFACE
Constructor
The constructor/destructors are the same as that described in TM::Index.
Methods
populate
$idx->populate (@list_of_keys)
To populate the index with canned results this method can be invoked. At this stage it is not very clever and may take quite some time
to work its way through a larger map. This is most likely something to be done in the background.
The list of keys to be passed in is a bit black magic. Your current best bet is to look at the index statistics method, and retrieve a
proposed list from there:
@optimized_keys = @{ $stats->{proposed_keys} };
$idx->populate (@optimized_keys[0..2]); # only take the first few
If this list is empty, nothing clever will happen.
statistics
$hashref = $idx->statistics
This returns a hash containing statistical information about certain keys, how much data is behind them, how often they are used when
adding information to the index, how often data is read out successfully. The "cost" component can give you an estimated about the
cost/benefit.
SEE ALSO
TM, TM::Index
COPYRIGHT AND LICENSE
Copyright 200[6] by Robert Barta, <drrho@cpan.org>
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.1 2008-04-10 TM::Index::Match(3pm)