Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Operation on multiple files
Top Forums Shell Programming and Scripting Operation on multiple files Post 302708383 by rdrtx1 on Monday 1st of October 2012 12:30:35 PM
Old 10-01-2012
Code:
 
#/bin/sh
awk '{a[FNR]+=$3;FNR>t?t=FNR:0;}END{for (i=1; i<=t; i++) print a[i];}' file_* > t_file
awk 'FILENAME ~ /t_file/ {a[NR]=$0;} FILENAME ~ /^file_/ {print $0 " " a[FNR] >> FILENAME ".tmp"}' t_file file_*
for file in file_*.tmp ; do mv $file ${file%.tmp} ; done
rm -f t_file

Note the last two lines move tmp files into original filenames. Comment out if not needed.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

multiple operation

Fellows I ran in to a problem this morning and could not figure out a solution to it. I have a file like OBJECT="ABC" GFT="JHU" DESCRIPTION="ABC MNCL JHDG " OBJECT="ABC" GFT="JHU" DESCRIPTION="ABC MNCL JHDG " OBJECT="ABC" GFT="JHU" DESCRIPTION="ABC MNCL JHDG " DESCRIPTION="ABC MNCL JHDG "... (2 Replies)
Discussion started by: ajnabi
2 Replies

2. Shell Programming and Scripting

Column operation : cosne and sine operation

I have a txt file with several columns and i want to peform an operation on two columns and output it to a new txt file . file.txt 900.00000 1 1 1 500.00000 500.00000 100000.000 4 4 1.45257346E-07 899.10834 ... (4 Replies)
Discussion started by: shashi792
4 Replies

3. UNIX for Dummies Questions & Answers

Using AWK: Extract data from multiple files and output to multiple new files

Hi, I'd like to process multiple files. For example: file1.txt file2.txt file3.txt Each file contains several lines of data. I want to extract a piece of data and output it to a new file. file1.txt ----> newfile1.txt file2.txt ----> newfile2.txt file3.txt ----> newfile3.txt Here is... (3 Replies)
Discussion started by: Liverpaul09
3 Replies

4. UNIX for Dummies Questions & Answers

How to delete original files after using a tar operation.

I have a list of log files in a directory. Once i tar them I need to remove the original log files. How do i do it? (4 Replies)
Discussion started by: manutd
4 Replies

5. Shell Programming and Scripting

[Solved] Mathematical operation in multiple files

Hi experts, I need to do a mathematical calculation between each data in 3 different files. Output is using formula (A11+B11)/(1+C11). INPUT : File A.txt A11 A12 A21 A22 File B.txt B11 B12 B21 B22 File C.txt C11 C12 C21 C22 OUTPUT: (A11+B11)/(1+C11) (A12+B12)/(1+C12)... (3 Replies)
Discussion started by: guns
3 Replies

6. Shell Programming and Scripting

awk math operation on two files

Hi, I need your help. I've got two files and i need to add 2nd line after occurrence of "Group No X" from data2.txt to 3rd line (after occurrence of "Group No X") from data1.txt. There is the same number of "Groups" in both files and the numbers of groups have the same pattern. data1.txt Group... (2 Replies)
Discussion started by: killerbee
2 Replies

7. UNIX for Dummies Questions & Answers

Run one script on multiple files and print out multiple files.

How can I run the following command on multiple files and print out the corresponding multiple files. perl script.pl genome.gff 1.txt > 1.gff However, there are multiples files of 1.txt, from 1----100.txt Thank you so much. No duplicate posting! Continue here. (0 Replies)
Discussion started by: grace_shen
0 Replies

8. Shell Programming and Scripting

Grep strings on multiple files and output to multiple files

Hi All, I want to use egrep on multiple files and the results should be output to multiple files. I am using the below code in my shell script(working in Ksh shell). However with this code I am not attaining the desired results. #!/bin/ksh ( a="/path/file1" b="path/file2" for file in... (4 Replies)
Discussion started by: am24
4 Replies

9. Shell Programming and Scripting

Multiple Replacement in a Text File in one operation (sed/awk) ?

Hi all, Saying we have two files: 1. A "Reference File" whose content is "Variable Name": "Variable Value" 2. A "Model File" whose content is a model program in which I want to substitute "VariableName" with their respective value to produce a third file "Program File" which would be a... (4 Replies)
Discussion started by: dae
4 Replies

10. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For... (12 Replies)
Discussion started by: as7951
12 Replies

LEARN ABOUT DEBIAN

setmaillist

setmaillist(1)						      General Commands Manual						    setmaillist(1)

NAME

       setmaillist - create a binary mailing list

SYNOPSIS

       setmaillist bin tmp

DESCRIPTION

       setmaillist reads a mailing list from its standard input.

       setmaillist writes the mailing list in a binary format to tmp; it then moves tmp to bin.  tmp and bin must be on the same filesystem.

       If there is a problem creating tmp, setmaillist complains and leaves bin alone.

       The binary mailing list format is portable across machines.

       setmaillist always creates bin world-readable.

MAILING LIST FORMAT

       The mailing list read by setmaillist is a series of lines.  NUL bytes are not allowed.

       If a line begins with a dot or slash, setmaillist takes the entire line as an include file name.

       If  a line begins with an ampersand, setmaillist takes the rest of the line as a recipient address.  If a line begins with a letter or num-
       ber, setmaillist takes the entire line as a recipient address.  Each recipient address must include a fully qualified domain name.  Recipi-
       ent addresses longer than 800 bytes are not allowed.

       setmaillist ignores blank lines and lines beginning with #.  It also ignores spaces and tabs at the ends of lines.

       For example,

	  god@heaven.af.mil
	  djb@silverton.berkeley.edu

       is a mailing list with two addresses.

SEE ALSO

       setforward(1), newinclude(1), printmaillist(1)

																    setmaillist(1)
All times are GMT -4. The time now is 12:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy