11-24-2008
awk script to calculate total
Hi
First field is the Record Type. A Record Type 5 can have multiple Record Type 6's before another Record Type 5 appears.
I want to calculate the total of fields at position 8-11 on Record type 6 when Record Type 5 has a field at position 11-14 equals to '2222'. then it should delete the lines of Record Type 6 except the the first Record Type 6 for that Record Type 5 only. Please help
1 101 201 301
5 test 4444 1233
6 1212 1222 3434 33
7 6464 122
8 3664 123
5 test 2222 1233
6 1212 1222 3434 33
7 4464 322
6 1212 4222 3434 33
7 4464 522
6 1212 6222 3434 33
6 1212 7222 3434 33
8 8664 823
5 test 4444 1233
6 1212 1222 3434 33
7 2464 122
8 3664 123
5 test 4444 1233
6 1212 1222 3434 33
7 7464 122
8 5664 123
5 test 2222 1233
6 61212 1222 3434 33
7 6764 122
8 9664 123
9 3332434 334344
so the output should be
1 101 201 301
5 test 4444 1233
6 1212 1222 3434 33
7 6464 122
8 3664 123
5 test 2222 1233
6 1212 18888 3434 33
7 4464 322
7 4464 522
8 8664 823
5 test 4444 1233
6 1212 1222 3434 33
7 2464 122
8 3664 123
5 test 4444 1233
6 1212 1222 3434 33
7 7464 122
8 5664 123
5 test 2222 1233
6 61212 1222 3434 33
7 6764 122
8 9664 123
9 3332434 334344
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I have a flat file like
10 steven
25 mike
47 Charles
127 Nancy
34 steven
23 mike
67 Charles
7761 Nancy
8 steven
54 mike
88 Charles
1267 Nancy
I need to calculate the total of steven and all the members , for this I am using like
grep "`sed -n 1p patterns.txt`"... (7 Replies)
Discussion started by: senthilkumar_ak
7 Replies
2. Shell Programming and Scripting
The file content is dynamic and using this format:
name1 number1
name2 number2
name3 number3
name4 number4
....................
Need a smooth way to calculate the sum of all the numbers in that file (number1 + number2 + number3 + number4........ = total ) (11 Replies)
Discussion started by: TehOne
11 Replies
3. Shell Programming and Scripting
Good afternoon! Im new at scripting and Im trying to write a script to
calculate total space, total used space and total free space in filesystem names matching a keyword (in this one we will use keyword virginia). Please dont be mean or harsh, like I said Im new and trying my best. Scripting... (4 Replies)
Discussion started by: bigben1220
4 Replies
4. Shell Programming and Scripting
Hi,
Just wondering, is there anyway I can get the total of logs generated by hours ? Let say I have these logs,
Sep 23 04:48:43 hsbcufs: NOTICE: realloccg /: file system full
Sep 23 04:48:47 hsbcufs: NOTICE: alloc: /: file system full
Sep 23 04:48:51 hsbcufs: NOTICE: realloccg /: file... (14 Replies)
Discussion started by: dehetoxic
14 Replies
5. Shell Programming and Scripting
HI
I have a file
# cat marks.txt
MARKS LIST
2013
Name english french chinese latin total_marks
wer 34 45 67 23
wqa 12 39 10 56
wsy 23 90 23 78
Now i need to find the total marks of each student using... (11 Replies)
Discussion started by: Priya Amaresh
11 Replies
6. Shell Programming and Scripting
Hi All ,
I have the following script as below , I tried to modify to meet the requirement , could someone help ? very thanks
================================================================================================
while read STR NAME; do
Total=0
MyString="$STR"
GetData () {... (18 Replies)
Discussion started by: ust3
18 Replies
7. Shell Programming and Scripting
Input file:
101M
10M10D20M1I70M
10M10D39M4I48M
10M10D91M
10M10I13M2I7M1I58M
10M10I15M1D66M
Output file:
101M 101 0 0
10M10D20M1I70M 100 1 10
10M10D39M4I48M 97 4 10
10M10D91M 101 0 10
10M10I13M2I7M1I58M 88 13 0
10M10I15M1D66M 91 10 1
I'm interested to count how many total of... (6 Replies)
Discussion started by: perl_beginner
6 Replies
8. Shell Programming and Scripting
Trying to use awk to print the lines in file that have either REF or SNV in $3, add a header line, sort by $4 in numerical order. The below code does that already, but where I am stuck is on the last part where the total lines are counted and printed under Total_Targets, under Targets_less_than is... (4 Replies)
Discussion started by: cmccabe
4 Replies
9. Shell Programming and Scripting
Hi
I am trying to calculate memory used by Linux System
free -m
total used free shared buffers cached
Mem: 32109 31010 1099 0 3600 7287
-/+ buffers/cache: 20121 11987
Swap: 10239 1282 8957
Now according to my requirement Im calculating memory using below cmd
free -m | awk 'NR==3{printf... (2 Replies)
Discussion started by: sam@sam
2 Replies
LEARN ABOUT DEBIAN
jifty::dbi::record::memcached
Jifty::DBI::Record::Memcached(3pm) User Contributed Perl Documentation Jifty::DBI::Record::Memcached(3pm)
NAME
Jifty::DBI::Record::Memcached - records with caching behavior
SYNOPSIS
package Myrecord;
use base qw/Jifty::DBI::Record::Memcached/;
DESCRIPTION
This module subclasses the main Jifty::DBI::Record package to add a caching layer.
The public interface remains the same, except that records which have been loaded in the last few seconds may be reused by subsequent get
or load methods without retrieving them from the database.
METHODS
load_from_hash
Overrides the implementation from Jifty::DBI::Record to add support for caching.
load_by_cols
Overrides the implementation from Jifty::DBI::Record to add support for caching.
_cache_config
You can override this method to change the duration of the caching from the default of 5 seconds.
For example, to cache records for up to 30 seconds, add the following method to your class:
sub _cache_config {
{ 'cache_for_sec' => 30 }
}
memcached_config
Returns a hash containing arguments to pass to Cache::Memcached during construction. The defaults are like:
(
services => [ '127.0.0.1:11211' ],
debug => 0,
)
You may want to override this method if you want a customized cache configuration:
sub memcached_config {
(
servers => [ '10.0.0.15:11211', '10.0.0.15:11212',
'10.0.0.17:11211', [ '10.0.0.17:11211', 3 ] ],
debug => 0,
compress_threshold => 10_000,
);
}
cache_key_prefix
Returns the prefix we should prepend to all cache keys. If you're using one memcached for multiple applications, you want this to be
different for each application or they might end up mingling data.
AUTHOR
Matt Knopp <mhat@netlag.com>
SEE ALSO
Jifty::DBI, Jifty::DBI::Record
perl v5.14.2 2010-09-21 Jifty::DBI::Record::Memcached(3pm)