help sum columns by break in first column with awk or sed or something. Post: 302282561

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sum columns

can anyone help me how do i add the colums using awk seperated by character @. for eg i have 3@4 2@9 5@1 the result should be 10 14 i tried using { sum+= $1 } END { print sum } but it just gives the result 10. can anyone help me with this one thank you and best regards

2. Shell Programming and Scripting

sum multiple columns based on column value

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

3. Shell Programming and Scripting

Need help with awk statement to break nth column in csv file into 3 separate columns

Hello Members, I have a csv file in the format below. Need help with awk statement to break nth column into 3 separate columns and export the changes to new file. input file --> file.csv cat file.csv|less "product/fruit/mango","location/asia/india","type/alphonso" need output in...

4. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

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. UNIX for Dummies Questions & Answers

Want the UNIX code - I want to sum of the 1st column wherever the first 2nd and 3rd columns r equal

I have the code for the below things.. File1 has the content as below 8859 0 subscriberCreate 18 0 subscriberPaymentMethodChange 1650 0 subscriberProfileUpdate 7668 0 subscriberStatusChange 13 4020100 subscriberProfileUpdate 1 4020129 subscriberStatusChange 2 4020307 subscriberCreate 8831...

6. Shell Programming and Scripting

Sum of Columns Base on First Column

Input :- Hd1;Hd2:hd3;Hd4;Hd5 X;1;2;3;4 Y;2;3;5;6 Z;3;5;6;7 X;10;11;24;16 Y;11;23;21;1 Z;10;13;14;15 X;0;1;2;0 K;0;0;0;0 K;0;0;0;0 I want Sum Data base on first column; Hd1;Hd2:hd3;Hd4;Hd5 X;11;14;29;20 Y;12;26;26;7 Z;13;18;20;22 K;0;0;0;0

7. Shell Programming and Scripting

Sum of columns using awk

Hello everyone I am a beginner in Shell scripting. Need your help to achieve desired result. I have a file (sample format below) 001g8aX0007jxLz xxxxxxxxxxxxxxx 9213974926411 CO-COMM-133 CO-L001-DLY 7769995578239 44938 1 1 ...

8. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For...

9. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

10. UNIX for Beginners Questions & Answers

Copy columns from one file into another and get sum of column values and row count

I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv abc.csv- UTF-8,,,,,,,,,,,,,,,,,,,,,,,,, ...

LEARN ABOUT DEBIAN

news::scan::poster

News::Scan::Poster(3pm) 				User Contributed Perl Documentation				   News::Scan::Poster(3pm)

NAME

       News::Scan::Poster - keep track of posters to a newsgroup

SYNOPSIS

	   use News::Scan::Poster;

	   my $poster = News::Scan::Poster->new($news_scan_article_obj);

DESCRIPTION

       This module provides a class whose objects can be used to keep track of cumulative statistics for posters to a Usenet newsgroup such as
       header volume or signature lines.

CONSTRUCTOR

       new ( ARTICLE )
	   "ARTICLE" should be a "News::Scan::Article" object or inherit from the "News::Scan::Article" class.

	   "new" performs some initialization and returns a "News::Scan::Poster" object.

METHODS

       address ( [ ADDRESS ] )
	   Returns the address of this poster represented as a "Mail::Internet" object.

	   If present, "ADDRESS" tells the object that the "Mail::Internet" object in "ADDRESS" is its address.  idea.

       attrib ( [ ATTRIBUTION ] )
	   Returns some nice attribution for this poster.

	   If present, "ATTRIBUTION" tells the object how it shall identify itself when asked.

       message_ids ( [ MESSAGE-ID ] )
	   Returns a list of Message-IDs attributed to this poster.

	   If present, "MESSAGE-ID" is added to this list of this poster's articles.

       volume
	   Returns the volume in bytes of the traffic generated by this poster.

       articles
	   Returns the number of articles attributed to this poster.

       posted_to
	   Returns a hash whose keys are newsgroup names and whose values are the number of times this poster has crossposted to the group of
	   interest and the corresponding newsgroup.

       crossposts
	   Returns the total number of crossposts this poster has sent through the group of interest.

       header_volume
	   Returns the volume in bytes generated by this poster's headers.

       header_lines
	   Returns the number of header lines generated by this poster.

       body_volume
	   Returns the volume in bytes generated by this poster's message bodies.

       body_lines
	   Returns the number of body lines generated by this poster.

       orig_volume
	   Returns the volume in bytes of original content generated by this poster.

       orig_lines
	   Returns the number of original lines generated by this poster.

       sig_volume
	   Returns the volume in bytes generated by this poster's signatures.

       sig_lines
	   Returns the number of signature lines generated by this poster.

SEE ALSO

       News::Scan, Mail::Address, News::Scan::Article

AUTHOR

       Greg Bacon <gbacon@cs.uah.edu>

COPYRIGHT

       Copyright (c) 1997 Greg Bacon.  All Rights Reserved.  This library is free software.  You may distribute and/or modify it under the same
       terms as Perl itself.

perl v5.10.1							    2000-04-13						   News::Scan::Poster(3pm)