Shell Programming and Scripting

As an simple example, I have the following files

fin1.zv being a one column set of number

Code:

1 90
2 80
3 60
4 30
5 20

fin2.zv is another file like this

Code:

1 10 20 30 40 50
2 60 70 80 90 0
3 90 80 70 60 50
4 40 30 20 10 0
5 10 20 30 40 50

Want to do $i - $2 / $2, let's say we store it in var[i]

var = $i - $2 / $2

where $2 is second column from the first file and $i is the ith column from the second file with i = 2 to i = NF

Want to output a file called file2.zp like this

$1 var[2] var[3] var[4] var[5] ...

where $1 is from file fin2.zv


I have a perl code which does this when I don't have the first column in the files.

Code:

    perl -e ' open(F1,"<$1"); open(F2,"<$2");  \
      while( ($p1=<F1>) && ($p2=<F2>) ) {      \
        foreach (split(/\s+/,$p2)) {           \
          print ($_ - $p1) / $p1," ";          \
        }                                      \
        print "\n"                             \
      }                                        \
      close(F1); close(F2); '                  \
      < fin1.zv fin2.zv                  \
      > fin2.zp

So I need to change it so that it takes account that the files now contain the additional first column as described and output the correct format I mentioned.

Please give an example of the desired output based on the data samples above.

Hello,
I think this has already been answered by someone on the forum apparently by me only.

P.S.
Enough of Free Service...!!!