Here is the sample input file:

6A subject1 Bldg1
6A subject1 Bldg2 Yes
6A subject1 Bldg3
8D subject2 Bldg1
8D subject2 Bldg2
8D subject2 Bldg3 Yes
E4 subject3 Bldg1
E4 subject3 Bldg2
E4 subject3 Bldg3
4F subject4 Bldg1
4F subject4 Bldg2
4F subject4 Bldg3 Yes
9F subject5 Bldg1 Yes
9F subject5 Bldg2
9F subject5 Bldg3 Yes
32 subject6 Bldg1
32 subject6 Bldg2

From this, I want two output files:

1. The entries that has "Yes" (only the first three fields.)

The output must look like this:

6A subject1 Bldg2
8D subject2 Bldg3
4F subject4 Bldg3
9F subject5 Bldg1
9F subject5 Bldg3

This will be straight forward, I think.

2. I want the entries where none of the field1 of the "yes" entries exist (and just column 1 and 2.)

The output must look like this:

E4 subject3
32 subject6

(All entries with 6A, 8D, 4F, 9F will get deleted as they have at least one "yes")

How to do this using a shell script?

Thanks,
Ajay