Visit Our UNIX and Linux User Community


How to add using awk command for a group?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to add using awk command for a group?
# 8  
Old 03-10-2016
It is easy to add the values for the 345/346 and 399/400 groups. Where would a line like 513,7.19 fit in? If it came in line No. 1, 2, 3, 4, or 5?
# 9  
Old 03-10-2016
Hello hemanthsaikumar,

Could you please try following and let me know if this helps you.
Code:
awk -F, '($1 == 345 || $1 == 346){A=A+$2} ($1 == 399 || $1 == 400){B=B+$2} END{if(A){print "Sum of group 345 and 346= " A};if(B){print "Sum of group 399 and 400= " B}}'  Input_file

Output will be as follows.
Code:
Sum of group 345 and 346= 26.44
Sum of group 399 and 400= 22

But again it will look for groups of 345, 346 and 399, 400 only. Let us know with complete details if your requirement differs from this code.


Thanks,
R. Singh
# 10  
Old 03-10-2016
As iam generating that input file no codes will be their other than that 4 codes.. so their is no chance of new codes or increment in records...

so how can we add them using awk or any other command ..? please help
# 11  
Old 03-10-2016
Code:
awk -F, 'NR%2 {split ($0, L); next} {printf "totalsumof%sand%s,%.2f\n", L[1], $1, L[2]+$2}' file4
totalsumof345and346,26.44
totalsumof399and400,22.00

And, as RavinderSingh13 already stated, don't come back complaining that that input file has changed!

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk Command to add Carriage Return and Line Feed

Hello, Can someone please share a Simple AWK command to append Carriage Return & Line Feed to the end of the file, If the Carriage Return & Line Feed does not exist ! Thanks (16 Replies)
Discussion started by: rosebud123
16 Replies

2. Shell Programming and Scripting

How to add printf statement in awk command?

hi all i need to add the prinf statement in awk command for the converted comma separated output.... below is my code : Code Credits :RudiC awk -F, 'NF==2 {next} {ITM=$1 AMT=$2+0 CNT=$3+0 TOTA+=$2 ... (4 Replies)
Discussion started by: hemanthsaikumar
4 Replies

3. Shell Programming and Scripting

Add two more fileds to awk command

This is what I was trying but failed to do so need help. cat 1.sql | awk '{printf("%s",NR%4 ? $0",":$0"\n")}' Output :- I want to add 2 more values for each line (hostname,user name) so the output should have hostname & username (testsrv01,test1) Output should be like... (4 Replies)
Discussion started by: lazydev
4 Replies

4. Shell Programming and Scripting

Group by using awk

Hi All, I have a file in the following format... ***************************************************** 11/10/27 12:09 : Input Record 11/10/27 12:10 : Input Record 11/10/27 12:10 : Input Record 11/10/27 12:10 : Input Record 11/10/27 12:10 : Input Record 11/10/27 12:10 : Input... (2 Replies)
Discussion started by: sraj142
2 Replies

5. Shell Programming and Scripting

Merge group numbers and add a column containing group names

Hi All I do have a file like this with 6 columns. Groups of data merge together and the group number is indicated above each group. 1 1 12 26 289 3.2e-027 GCGTATGGCGGC 2 12 26 215 6.7e+006 TTCCACCTTTTG 3 9 26 175 ... (1 Reply)
Discussion started by: Lucky Ali
1 Replies

6. Shell Programming and Scripting

Merge group numbers and add a column containing group names

I have a file in the following format. Groups of data merge together and the group number is indicated above each group. 1 adrf dfgr dfg 2 dfgr dfgr 3 dfef dfr fd 4 fgrt fgr fgg 5 fgrt fgr (3 Replies)
Discussion started by: Lucky Ali
3 Replies

7. Shell Programming and Scripting

awk group by

Hi I have a file in this format: ... 04/May/2009 16 04/May/2009 1 05/May/2009 3 05/May/2009 5 06/May/2009 1 06/May/2009 3 ... I need to sum for every day, What is the best way? Thanks all (2 Replies)
Discussion started by: mutti
2 Replies

8. Shell Programming and Scripting

awk help required to group output and print a part of group line and original line

Hi, Need awk help to group and print lines to format the output as shown below INPUT FORMAT set echo on set heading on set spool on /* SCHEMA1 */ CREATE TABLE T1; /* SCHEMA1 */ CREATE TABLE T2; /* SCHEMA1 */ CREATE TABLE T3; /* SCHEMA1 */ CREATE TABLE T4; /* SCHEMA1 */ CREATE TABLE T5;... (5 Replies)
Discussion started by: rajan_san
5 Replies

9. UNIX for Dummies Questions & Answers

Add group

Hi All, How can I add few existing groups into a group? eg. Currently, I have - projgrp1 for proj1 with members proj1usr1, proj1usr2, proj1usr3..proj1usr10 - projgrp2 for proj2 with members proj2usr1, proj2usr2 - projgrp3 for proj3 wiht members proj3usr1, proj3usr3 Now, I would like to... (3 Replies)
Discussion started by: tifmils
3 Replies

10. Shell Programming and Scripting

command to add users to group

does a command exist to add users to more than one group? i think the usermod command can do this but i'm not really sure. past ways of me doing this has always been to just hack the /etc/group file and put the user in whatever group i need him to be in. however, vi..ing files like /etc/groups... (2 Replies)
Discussion started by: Terrible
2 Replies

Featured Tech Videos