10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Dear Experts,
I have input file which is comma separated, has 4 columns like below,
BRAND,COUNTRY,MODEL,COUNT
NIKE,USA,DUMMY,5
NIKE,USA,ORIGINAL,10
PUMA,FRANCE,DUMMY,20
PUMA,FRANCE,ORIGINAL,15
ADIDAS,ITALY,DUMMY,50
ADIDAS,ITALY,ORIGINAL,50
SPIKE,CHINA,DUMMY,1O
And expected output add... (2 Replies)
Discussion started by: ricky1991
2 Replies
2. Shell Programming and Scripting
HI Guys,
I gave Input file F.Txt
ID H1 H2 H3 H4 H5
A 5 6 7 8 9
B 4 65 4 4 7
C 4 4 4 4 4
D 4 4 4 4 4
Output :-
ID H1 H2 H3 H4 H5
Total 17 79 19 20 24
Sum of Each Columns (8 Replies)
Discussion started by: pareshkp
8 Replies
3. Shell Programming and Scripting
HI All,
I'm embedding SQL query in Script which gives following output:
Assignee Group Total
ABC Group1 17
PQR Group2 5
PQR Group3 6
XYZ Group1 10
XYZ Group3 5
I have saved the above output in a file.
How do i sum up the contents of this output so as to get following output:
... (4 Replies)
Discussion started by: Khushbu
4 Replies
4. Shell Programming and Scripting
Hi Friends,
I have a file with fields separated with comma. How to print sum of each field of the file?
Eg:
input file
1,3,6,7
2,1,2,1
0,1,1,0
I want to sum each field separately.
Output file
3,5,9,8
Thanks,
Suresh (2 Replies)
Discussion started by: suresh3566
2 Replies
5. Shell Programming and Scripting
Hi all, I know this sounds suspiciously like a homework course; but, it is not.
My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies
6. Shell Programming and Scripting
Hi All,
I'm new to this forum. So please be patience with me! :)
I have a file that looks like this (all rows have the same number of columns):
19 20 30 15 17 38 51 60 74 85 96 07 ....
10 20 44 59 39 88 13 77 30 10 11 12 ....
.
.
.
I want to sum the value of first field to all the... (2 Replies)
Discussion started by: Aderson Nascime
2 Replies
7. Shell Programming and Scripting
how can i group by same columns by another columns in Bash
Eq. this is a csv file
Co1 Co2 Co3 Co4
A A 1,000 1,000
A B 2,000 1,250
A A 2,000 3,002
A C 2,000 3,005
how can i get the result of like this
Co1 Co2 Co3 Co4
A A 3,000 ... (5 Replies)
Discussion started by: qjlongs
5 Replies
8. Shell Programming and Scripting
Hi All,
happy new year.
I have a file with 4xN columns like
0.0000e+00 0.0000e+00 7.199E+07 7.123E+07 6.976E+07 6.482E+07 5.256E+07 2.523E+07
0.0000e+00 0.0000e+00 8.641E+07 8.550E+07 8.373E+07 7.780E+07 6.309E+07 3.028E+07... (8 Replies)
Discussion started by: f_o_555
8 Replies
9. Shell Programming and Scripting
Hi All,
I have like this
M17XX-050-01 0100000000 QQSSS
0.0000e+00 1.712E+06 1.255E+07 0.0000e+00
0.0000e+00 1.722E+06 1.263E+07 0.0000e+00
...
0.0000e+00 1.204E+06 8.829E+06 0.0000e+00
M17XX-050-01 0100000000 WWSSS
0.0000e+00 7.564E+03 1.165E+01 0.0000e+00... (6 Replies)
Discussion started by: f_o_555
6 Replies
10. Shell Programming and Scripting
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 (7 Replies)
Discussion started by: phone_book
7 Replies