awk multiply values contained in 2 different files

Tags

shell scripts

Top Forums Shell Programming and Scripting awk multiply values contained in 2 different files

03-06-2013

Registered User

4, 1

Join Date: Feb 2013

Last Activity: 6 March 2013, 6:25 AM EST

Posts: 4

Thanks Given: 1

Thanked 1 Time in 1 Post

Here is the code that I use now:

Code:

paste $filein1 $filein2 | nawk ' BEGIN {begdata=0}{
                if ((NR>2 && NF==12) || begdata==1) {
                  for(i=1;i<=NF/2;i++) {
                    printf(" %12.5E",$i*$(NF/2+i));
                  }
                  printf("\n");
                  begdata=1;
                 }
                else
                {
                  print substr($0,0,length($0)/2)
                }
              }' > $fileout

begdata is a boolean used to detect when my data begin (first time NF==12).

Thanks a lot bipinajith and also of course Don Cragun to detect the bug !!!

Last edited by Youm; 03-06-2013 at 07:25 AM..

This User Gave Thanks to Youm For This Post:

Youm

View Public Profile for Youm

Find all posts by Youm

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Multiply values from a file

Hi All, I extracted a file using an awk command like this awk '{print substr($0,78,5)"," substr($0,59,6) "," substr($0,81,3) "," substr($0,11,7)}' file1 >> OUTPUT cat OUTPUT 00001,100000,005,0000080 00001,100000,008,0000220 00001,100000,001,0001000 00010,100000,001,0000400 I want...

2. Shell Programming and Scripting

Compare two files column values using awk

Judi # cat File1 judi /export/home 76 judi /usr 83 judi # judi # cat File2 judi /export/home 79 judi /usr 82 judi # if COLUMN3 of File2 is greater that COLUMN3 of File1, then print File2's lines juid /export/home 79 Code tags please

3. Shell Programming and Scripting

How to search, replace and multiply variable within awk?

I have a file that reports the size of disks GB's or TB's - I need the file to report everything in MB's. Here is an extract of the file - the last column is the disk size. 19BC 2363 20G 1AA3 2363 2.93T 1A94 2363 750G Whenever I come across a G I want to delete the G and multiply by...

4. Shell Programming and Scripting

Creating a Third File from Information Contained in Two Files

In advance, I appreciate any help or tips. I apologize for not providing examples of scripts I have already tried, the reason is that I am new to programming and do not really no where to start. I think this is possible with awk, but do not know how to go about learning how to write the script...

5. UNIX for Dummies Questions & Answers

Searching for terms contained in 2 separate files

Hi All ! As a dummy, I try to search for multiple string of characters contained in 2 types of list. Not clear? No it's not. Example: I have a tab-delimited file called "inventory" with 2 columns that looks like that: #ref #year,color xrt3 2000,blue gf5 2000,red,green,yellow...

6. Shell Programming and Scripting

multiply with awk

HI help i have cc 9+37.50 328611.50 688498.25 42.38 cc 66+62.50 328636.50 688498.42 42.58 i want to make o/p cc 9+3750 328611.50 688498.25 42.38 cc 66+6250 328636.50 688498.42 42.58 plz help

7. Shell Programming and Scripting

Help fixing awk code to print values from 2 files

Hi everyone, Please help on this: I have file1: <file title="Title 1 and 2"> <report> <title>Title 1</title> <number>No. 1234</number> <address>Address 1</address> <date>October 07, 2009</date> <description>Some text</description> </report> ...

8. Shell Programming and Scripting

Multiply numbers from different files

Hi All, I have tried few things with this but it did not help much. I have some 200,000 files in a directory. There are two sets of files. 1. Files with extension .dat with file names like these (1.dat, 2.dat, 5.dat, 8.dat....200000.dat) 2. Another set of files with .txt extension and...

9. Shell Programming and Scripting

awk multiply fields within lines, then total

Here is my scenario, I have two columns. I need to add the first columns (the easy part). The second column is a percent that I need to subtract by 100 then multiply against the first column for each line, then sum the output for a total Here is the input: 942330863 96 942172150 95...

10. Programming

random array index returning values not contained

For kicks I wrote up a Password generator after lunch. Let me start with the code: unsigned int x,y,z,c; unsigned int KISS(); unsigned int devrand(); int main( int argc, char** argv ) { int i, j = 1; char pwd = "abcdefghijklmnopqrstuvwxyz" ...

Shell Programming and Scripting