Shell Programming and Scripting

Hi Gents,

I have 2 files as seen below.

File 1:

Code:

 9   1020
10   1001
11   1001
12   1002
13   1003
14   1004
15   1004

File 2:

Code:

 9  1000
11  1001
12  1002
13  1003
15  1004

I would like to the following

1. Filter the data taking in consideration the values in File2 - Colum1 as reference, and make two list:

- One with the values not present in File 2
Example

Code:

10   1001
14   1004

- Other list of the values which dont match in , in the list should be:
Expample

Code:

9 1020
9 1000

Thanks in advance
To anyone who can help me with this

Check your man page of grep. Does your version supports the -f and -v options?

Hi Franklin
Yes grep have options -f & -v

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

Hi Franklin
Yes grep have options -f & -v

Another way with sorted files:

Code:

join file1 file2 -a 1 |awk 'NF==2{print > "notpresent";next;}$2!=$3{print $1FS$2RS$1FS$3>"notmatch"}'

Have you give it a try?

Another way with sorted files:

Code:

join file1 file2 -a 1 |awk 'NF==2{print > "notpresent";next;}$2!=$3{print $1FS$2RS$1FS$3>"notmatch"}'

Thanks a lot the code works perfect