HELP with Unix scripts in summing columns in a file.
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Hi guys, i'm a new guy here, and it's my first time creating a unix script.
can you guys help me out here? i'd really appreciate it.
Here's my problem:
This is the file i'm using, it has 6 columns, the first three columns are like the key columns, and i put one header row. I need to sum the values of 4th, 5th and 6th row, by grouping each row by date, prod id and store id.
Code:
1st file:
date prod id store id amt 1 amt 2 amt 3
20111017 45671 11801 -12 -12348 1080
20111017 45671 11801 12 12348 1030
20111018 45672 11802 7 7868 990
20111018 45672 11802 4 4496 950
20111019 45673 11803 -12 -12348 910
20111019 45674 11804 12 12348 866
then i have this second file:
this file contains a list of "prod id's" that should be ignored in the first file.
2nd file:
Code:
prod id
45671
The third file consists of a list of "store id's" that should be ignored from the 1st file.
3rd file:
Code:
store id
11803
So basically, i need to come up with a script to sum the 4th, 5th and 6th columns of the first file, while taking consideration, those that are present in the 2nd and 3rd file, so that those that should be ignored should not be included when columns are summed.
I would really appreciate a lot of love and help and mercy from you guys.
Thanks a lot!
2. Relevant commands, code, scripts, algorithms:
3. The attempts at a solution (include all code and scripts):
4. Complete Name of School (University), City (State), Country, Name of Professor, and Course Number (Link to Course):
Note: Without school/professor/course information, you will be banned if you post here! You must complete the entire template (not just parts of it).
Hi everyone,
I need a help on Unix scripting.
I have a file is like this
Date Amt
20071205 10
20071204 10
20071203 200
20071204 300
20071203 400
20071205 140
20071203 100
20071205 100... (1 Reply)
Hi All,
I have a file like -
num.txt
12, 34, 65, line1
34, 65, 89, line2
43, 65, 77, line3
I want to do two things -
1. Add first three columns of each line and print the line with largest value.
i.e. (12+34+65) for 1st line and so on.
2. Add middle column of each line i.e.... (3 Replies)
Basically I have to process a text file which has been sorted this way:
John 12
John 13
John 10
John 900
Peter 20
Peter 30
Peter 32
The first column is a name, and the second an arbitrary value, both delimited by a space. How can I sum them up such that it would become:
John 935... (2 Replies)
1. The problem statement, all variables and given/known data:
Hi guys, i'm a new guy here, and it's my first time creating a unix script.
can you guys help me out here? i'd really appreciate it. :(
Here's my problem:
This is the file i'm using, it has 6 columns, the first three columns are... (12 Replies)
a,b,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,aa,bb,cc,dd,ee,ff,gg,hh,ii
a thru ii are digits and strings....
The awk needed....if coloumn 9 == i (coloumn 9 is string ), output the sum of x's(coloumn 22 ) in all records and sum of y's (coloumn 23 ) in all records in a file (records.txt).... (6 Replies)
Can anyone tell me how sum values in each record of a file and append that value to the end? For instance a typical record will be:
FY12,Budget,771100,,,,,,,,,250,-250
I'd like the record to become
FY12,Budget,771100,,,,,,,,,250,-250,0
which can be put into another file.
Thank you. (6 Replies)
I have a file with the following format
AAAAA 1.34B 0.76B 0.00B 0.00B 0.00B 0.00B 0.00B 0.00B 0.00B 0.00B 0.00B 0.00B 0.00B 0.00B 0.90B 0.00B 0.00B 0.46B 0.00B 0.03B 0.00B ... (4 Replies)
Hello,
I am facing issue in summing up a column in unix.I am displaying a column sum up to 4 decimal places and below is the code snippet
sed '1d' abc.csv | cut -d',' -f7 | awk '{s+=$1}END{ printf("%.4f\n",s)}'
-170552450514.8603
example of data values in the column(not... (3 Replies)
Discussion started by: karthik adiga
3 Replies
LEARN ABOUT V7
debconf-mergetemplate
DEBCONF-MERGETEMPLATE(1) Debconf DEBCONF-MERGETEMPLATE(1)NAME
debconf-mergetemplate - merge together multiple debconf template files
SYNOPSIS
debconf-mergetemplate [options] [templates.ll ...] templates
DESCRIPTION
Note: This utility is deprecated. You should switch to using po-debconf's po2debconf program.
This program is useful if you have multiple debconf templates files which you want to merge together into one big file. All the specified
files will be read in, merged, and output to standard output.
This can be especially useful if you are dealing with translated template files. In this case, you might have your main template file, plus
several other files provided by the translators. These files will have translated fields in them, and maybe the translators left in the
english versions of the fields they translated, for their reference.
So, you want to merge together all the translated templates files with your main templates file. Any fields that are unique to the
translated files need to be added in to the correct templates, but any fields they have in common should be superseded by the fields in the
main file (which might be more up-to-date).
This program handles that case properly, just list each of the translated templates files, and then your main templates file last.
OPTIONS --outdated
Merge in even outdated translations. The default is to drop them with a warning message.
--drop-old-templates
If a translation has an entire template that is not in the master file (and thus is probably an old template), drop that entire
template.
SEE ALSO debconf-getlang(1)AUTHOR
Joey Hess <joeyh@debian.org>
2012-09-10 DEBCONF-MERGETEMPLATE(1)