Shell Programming and Scripting

Hi All
I have a problem that I am not able to resolve.
Briefly, I have a file like this:

Code:

ID_1 10
ID_2 15
ID_3 32
ID_4 45
ID_5 66
ID_6 79
ID_7 88

This file is numerically ordered for the 2th column.
And another file containing a list of IDs(just one in this example)

Code:

ID_4

What I would like to obtain is a file like that, in which for each entry in file 2, output the relative ID and the first plus and minus n(set 3 for example) ID(and the difference between column 2) of file 1.

Code:

ID_4 ID_1(-35) ID_2(-20) ID_3(-13) ID_5(21) ID_6(34) ID_7(43)

If you need further details do not hesitate to contact me!
Thank you!

PS:There are same cases of different IDs and same number.In this case just refer to the order of file.

Hi, try:

Code:

awk '
  NR==FNR {
    n=NR
    I[n]=$1
    L[$1]=n
    V[n]=$2
    next
  }
  {
    j=2
    for(i=1; i<=n; i++) { 
      if(i!=L[$1]) {
        $(j++)=I[i] "(" V[i]-V[L[$1]] ")"
      }
    }
  }
  1
' file1 file2

Thank you for the help!
Unfortunately the awk command does not work(^ syntax error)!!
I tried also with the list posted above.
Any other suggestion?
Thank you

What is your OS ands version?

Hi
Unfortunately now I am not at work and I do not remember the version :-(
However I am working on debian OS.

I noticed that something had gone wrong with posting the suggestion. I corrected it, perhaps you could try again...

Thank you Scrutinizer for following my issue!
As soon as I will have the possibility I will run the command and I ll let you know!
Best