Re: scripting help

Yes, it works. Thanks.



Ed Morton wrote:
mainak.sen@xxxxxxxxx wrote:
Hi,
I have two files (file 1 has one column and file 2 four columns), I
have to choose the rows of file 2 where column 2 & 3 of file 2 matches
with column 1 of file 1. Anybody has any idea?


To add to this with an example,

file 1 :
1_8
1_9
1_10
1_11


file 2 :
1 1_500 1_600 0.000 1.0 0.0 0.0
1 1_500 1_500 0.000 0.0 0.0 1.0
1 1_9 1_100 0.000 0.50000 0.50000 0.00000
1 1_9 1_200 0.000 0.50000 0.50000 0.00000
1 1_9 1_400 0.000 1.0 0.0 0.0
....
1 1_8 1_500 2.107 0.59766 0.40234 0.00000
1 1_8 1_9 2.107 0.89431 0.10569 0.00000
1 1_8 1_300 2.107 0.0 1.0 0.0


merge two files such that it will print
1 1_8 1_9 2.107 0.89431 0.10569 0.00000


i.e. the rows of file 2 where col.2 and col.3 matches with any two
entries in file 1

Any help would be extremely well appreciated.
Thanks


awk 'NR==FNR{arr[$1];next}($2 in arr)&&($3 in arr)' file1 file2

What if col2 and col3 of file2 have the same value and only match with
one entry in file1?

Ed.

.

Relevant Pages

  • Re: scripting help
    ... What if col2 and col3 of file2 have the same value and only match with one entry in file1? ...
    (comp.unix.shell)
  • Re: how to do the file1-file2?
    ... Ed Morton wrote: ... I want a shell could have the result: remove all lines in file1, ... That might remove more than desired if file2 contains RE wildcards. ... comm -13 file2 file1 ...
    (comp.unix.shell)
  • Re: Find lines in file2 that are not in file1
    ... Ed Morton wrote: ... > Jonny wrote: ... And if you just wanted the unique lines in file2 that are not in file1, ...
    (comp.unix.shell)
  • Re: Syslog Monitoring
    ... Ed Morton wrote: ... >> 'breaks' this heartbeat entry will no longer be put into the log. ... >> Does anyone have a script that does this? ...
    (comp.unix.questions)