Mulitiplication with two files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Mulitiplication with two files
# 1  
Old 04-05-2013
Question Mulitiplication with two files

Hello everyone,

I want to say that this thread is not a homework. I need a csh or sh script to perturbate a 3D earthquke wave velocity model I developed so I just want to learn how to multiply each node in one file with the same nodes in the other file and write it to another file. the example below is just random number.
The real sizes of my matrix is 35*233.



I have two matrices at same sizes. I need to re-calculate the numbers in matrix A according to the percentages in martix B

it is like

matrix A is



Code:
 10.00  20.00  30.00  40.00  
 60.00  70.00  80.00  90.00
 20.00  30.00  80.00  50.00

martix B is



Code:
 00.08  00.05  00.06  00.07
 00.05  00.06  00.08  00.06
 00.02  00.01  00.09  00.07

Matrix C should be calculated like



Code:
10+(10*0.08) 20+(20*0.05) 30+(30+0.06) 40+(40+0.07)
60+(60*0.05) 70+(70*0.06) 80+(80*0.08) 90+ (90*0.06)
20+(20*0.02) 30+(30*0.01) 80+(80*0.09) 50+(50*0.07)

and the result should look like

Code:
 10.80  21.00  31.80  42.80
 63.00  74.20  86.40  95.40
 20.04  30.30  87.20  53.50

There are no number larger then 99. there is 2 digit before and after the dots. and 2 spaces between the numbers
# 2  
Old 04-05-2013
Try This :

Code:
 
awk 'FNR==NR{for(i=1;i<=NF;i++) e[FNR,i]=$i;next}
{for(i=1;i<=NF;i++)
 
printf("%s%s",e[FNR,i]+e[FNR,i]*$i,i==NF?"\n":" ")
}' A B

This User Gave Thanks to i150371485 For This Post:
# 3  
Old 04-05-2013
This may be a start

Code:
$ paste sample3.txt sample4.txt | awk '{v1=$1+($1*$5);v2=$2+($2*$6); printf "%-6.2f %-6.2f\n",v1,v2}'
10.00  21.60
63.00  74.20
20.40  30.30

Above does the first two output columns, you could continue for the next two columns
This User Gave Thanks to joeyg For This Post:
# 4  
Old 04-05-2013
Hello dear,

It worked correctly. Thank you so much!Smilie

---------- Post updated at 07:08 AM ---------- Previous update was at 07:07 AM ----------

Quote:
Originally Posted by joeyg
Code:
$ paste sample3.txt sample4.txt | awk '{v1=$1+($1*$5);v2=$2+($2*$6); printf "%-6.2f %-6.2f\n",v1,v2}'
10.00  21.60
63.00  74.20
20.40  30.30

Above does the first two output columns, you could continue for the next two columns
Thank you that would work too
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Automate splitting of files , scp files as each split completes and combine files on target server

i use the split command to split a one terabyte backup file into 10 chunks of 100 GB each. The files are split one after the other. While the files is being split, I will like to scp the files one after the other as soon as the previous one completes, from server A to Server B. Then on server B ,... (2 Replies)
Discussion started by: malaika
2 Replies

2. Shell Programming and Scripting

Shell script for field wise record count for different Files .csv files

Hi, Very good wishes to all! Please help to provide the shell script for generating the record counts in filed wise from the .csv file My question: Source file: Field1 Field2 Field3 abc 12f sLm 1234 hjd 12d Hyd 34 Chn My target file should generate the .csv file with the... (14 Replies)
Discussion started by: Kirands
14 Replies

3. Shell Programming and Scripting

Append string to all the files inside a directory excluding subdirectories and .zip files

Hii, Could someone help me to append string to the starting of all the filenames inside a directory but it should exclude .zip files and subdirectories. Eg. file1: test1.log file2: test2.log file3 test.zip After running the script file1: string_test1.log file2: string_test2.log file3:... (4 Replies)
Discussion started by: Ravi Kishore
4 Replies

4. UNIX for Advanced & Expert Users

Find all files in the current directory excluding hidden files and directories

Find all files in the current directory only excluding hidden directories and files. For the below command, though it's not deleting hidden files.. it is traversing through the hidden directories and listing normal which should be avoided. `find . \( ! -name ".*" -prune \) -mtime +${n_days}... (7 Replies)
Discussion started by: ksailesh1
7 Replies

5. Shell Programming and Scripting

How to create zip/gz/tar files for if the files are older than particular days in UNIX or Linux?

I need a script file for backup (zip or tar or gz) of old log files in our unix server (causing the space problem). Could you please help me to create the zip or gz files for each log files in current directory and sub-directories also? I found one command which is to create gz file for the... (4 Replies)
Discussion started by: Mallikgm
4 Replies

6. Shell Programming and Scripting

need a shell script to extract the files from source file and check whether those files existonserve

Hi, I am new to shell scripting.Please help me on this.I am using solaris 10 OS and shell i am using is # echo $0 -sh My requirement is i have source file say makefile.I need to extract files with extensions (.c |.cxx |.h |.hxx |.sc) from the makefile.after doing so i need to check whether... (13 Replies)
Discussion started by: muraliinfy04
13 Replies

7. UNIX for Dummies Questions & Answers

write a program in c in unix that display the files(includ sub-direc and files within) in a sorted

the sorting is based on name of file, file size modification time stamps o f file it should dislay the output in the following format "." and ".." enteries should be ignored please give some idea how to do it (1 Reply)
Discussion started by: pappu kumar jha
1 Replies

8. Shell Programming and Scripting

How to extract data from indexed files (ISAM files) maintained in an unix server.

Hi, Could someone please assist on a quick way of How to extract data from indexed files (ISAM files) maintained in an UNIX(AIX) server.The file data needs to be extracted in flat text file or CSV or excel format . Usually we have programs in microfocus COBOL to extract data, but would like... (2 Replies)
Discussion started by: devina
2 Replies

9. Shell Programming and Scripting

How to retrieve all the linked script files/ctl files/sql files?

Hi I am going to migrate our datawarehouse system from HP Tru 64 Unix to the Red Hat Linux. Inside the box, it is running around 40 cron jobs; inside each cron job, it is calling other shell script files, and the shell script files may again call other shell script files or ctl files(for... (1 Reply)
Discussion started by: franksubramania
1 Replies
Login or Register to Ask a Question