Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Adding the trailers in two files

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Adding the trailers in two files
# 1  
Old 04-28-2011
Adding the trailers in two files
I have two files
File1 has trailer as below
TR|2|120
File2 has trailer as below
TR|1|100

it should add both the fields from trailer of file 1 and 2....so that file2 has a trailer as
TR|3|220
# 2  
Old 04-28-2011
Code:
#!/usr/bin/ksh
 
for f in file*
do
 tail -1 $f
done | (
 IFS="${IFS}|" a=0 b=0
 
 while read t1 t2 t3
 do
  (( a += $t2 ))
  (( b += $t3 ))
 done
 
 echo "$t1|$a|$b" >>$ofile
 )

It's not wise to add pipe to IFS for long, so in a subshell.
# 3  
Old 04-28-2011
Code:
awk '{a[$1]+=$2;b[$1]+=$3}
    END{for (i in a) print i,a[i],b[i]}' FS="|" OFS="|" File1 File2

# 4  
Old 04-29-2011
I need to learn more awk. How does the awk get to the last line of file1 and file2 before adding?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding two files

I have a file which entry is below cat file1 user1 user2 user3 another file, which entry is below cat file2 Proj1 Fin Proj2 Marketing I want O/P as below Delete User Profile "user1" FROM Proj1 Fin Delete User Profile "user1" FROM Proj2 Marketing Delete User Profile "user2"... (4 Replies)
Discussion started by: anshu ranjan
4 Replies

2. UNIX for Dummies Questions & Answers

Adding unzipped files to a Zip

Hey all, I have a zip file which I received, and I need to replace one of the files inside of it. I tried the obvious solution of unzipping the zip, replacing the file, and rezipping, but the following happened: Original Zip Size: 79MB Unzipped Size 80MB New Zip: 36MB When I feed the... (2 Replies)
Discussion started by: DeanLeitersdorf
2 Replies

3. Red Hat

RPM package, conditional adding files in "%files" section

Hello, Is it possible to specify a list of files to be included in an RPM package (section "% files") according to some condtions. For example, if a particular condition is true, do not include the file "X". If not include it. Thank you for your help. Regards (1 Reply)
Discussion started by: louzorios
1 Replies

4. Shell Programming and Scripting

Help with joining files and adding headers to files

Hi, I have about 20 tab delimited text files that have non sequential numbering such as: UCD2.summary.txt UCD45.summary.txt UCD56.summery.txt The first column of each file has the same number of lines and content. The next 2 column have data points: i.e UCD2.summary.txt: a 8.9 ... (8 Replies)
Discussion started by: rrdavis
8 Replies

5. Shell Programming and Scripting

Adding Multiple Files via Columns

I have a number of files with multiple rows that I need to add together. Let say I have 10 files: Each file has a great number of rows and columns. I need to add these files together the following way. In other words, If, for example, file A occupies Columns 1 to 19, I want to add file B... (7 Replies)
Discussion started by: Ernst
7 Replies

6. UNIX for Dummies Questions & Answers

Adding new columns to txt files

Dear all, I have a question. I have a txt.file as below. i want to add 3 more columns: column3=conlum 2*column2; column4=(1-column2)*(1-column2); column5=1-column3-column4. Do you know how to do it? Thanks a lot! file: column1 column2 a 1 b 20 c 30 d 3 ... (2 Replies)
Discussion started by: forevertl
2 Replies

7. Shell Programming and Scripting

renaming files or adding a name in the beginning of all files in a folder

Hi All I have a folder that contains hundreds of file with a names 3.msa 4.msa 21.msa 6.msa 345.msa 456.msa 98.msa ... ... ... I need rename each of this file by adding "core_" in the begiining of each file such as core_3.msa core_4.msa core_21.msa (4 Replies)
Discussion started by: Lucky Ali
4 Replies

8. Shell Programming and Scripting

Adding columns of two files

Hello everyone, I have two files containing 6 columns and thousands of rows. I want to add them (i.e. first column of first file + first column of second file and so on) and print the output in a third file. Can you please help me. Thanks a lot (7 Replies)
Discussion started by: chandra321
7 Replies

9. Shell Programming and Scripting

awk adding columns from different files

Hi, I have two files and I need to add column 3 of file1 to column 3 of file 2 > file3 I also need to repeat for column 4. Thanks (1 Reply)
Discussion started by: dsstamps
1 Replies

10. Shell Programming and Scripting

adding two files

Dear Experts, I am facing some problem. I have two files, every field is separated by comma "," separator. And the value is in numeric FILEA 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 FILE B ... (7 Replies)
Discussion started by: shary
7 Replies
Login or Register to Ask a Question