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?
# 1  
Old 03-10-2016
How to add using awk command for a group?

hi all

below is the input file contains a code followed by amount

input file
Code:
345,5.86
346,20.58
399,10.00
400,12.00


i need the output in the following way outputfile

Code:
totalsumof345and346,26.44
totalsumof399and400,22.00

i have the awk command to add of similar group ..can we do the add for two different groups using awk..?

thanks in advance

Last edited by hemanthsaikumar; 03-10-2016 at 05:03 AM..
# 2  
Old 03-10-2016
What defines a "group", and what separates two groups? And, when to apply the "and" and when the "," in the output?
# 3  
Old 03-10-2016
hi ,
sorry i modified the input and output.

group is the code values like 345,346...

i have the input file format constant as stated above but i need to combine and need to get the total as shown in outputfile
# 4  
Old 03-10-2016
Quote:
Originally Posted by hemanthsaikumar
hi ,
sorry i modified the input and output.

group is the code values like 345,346...

i have the input file format constant as stated above but i need to combine and need to get the total as shown in outputfile
That does not answer the question RudiC asked.

How do you determine that 345 and 346 are "similar groups" and that 399 is not "similar" to 345 or 346?
# 5  
Old 03-10-2016
hi,
I generated the report which i gave as input file and codes(345,346,399,400) in it are constant the amount will vary when i generate the input reports .Now i have to create the sum as shown in output file ...by passing the inputfile to the script to generate the output file.. Hope it clear ..Smilie
# 6  
Old 03-10-2016
Why don't you combine 345 and 400 into one group, and 346 and 399 into another? Are groups always groups of two? Or three?
This User Gave Thanks to RudiC For This Post:
# 7  
Old 03-10-2016
hi Rudic,
the input file will be constant,amount may varies and the add will be on group of 2...

as per my requirement i have to add 345,346 and 399,400 ...is it possible to perform add ..? if yes could you please help..?

Thanks in advance
Login or Register to Ask a Question

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
Login or Register to Ask a Question