Shell Programming and Scripting

AA 3
BB 1
CC 3
DD 6
EE 2
FF 6

1 EE
3 CC
2 AA

cat Input_file1
AA 3
BB 1
CC 3
DD 6
EE 2
FF 6

cat Input_file2
1 EE
3 CC
2 AA
12 AF

awk 'BEGIN{print "ids which are present in file1 and file2 both:"} FNR==NR{A[$1]=$0;next} ($2 in A){print;delete A[$2];next} !($2 in A){Q=Q?Q ORS $0:$0}  END{print "ids which are present in file2 and not in file1" ORS Q;print "ids which  are present in file1 and not in file2.";for(i in A){print A[i]}}' Input_file1  Input_file2

ids which are present in file1 and file2 both:
1 EE
3 CC
2 AA
ids which are present in file2 and not in file1
12 AF
ids which  are present in file1 and not in file2.
BB 1
DD 6
FF 6

awk 'FNR==NR{A[$1 OFS $2]=$0;next} (($2 OFS $1) in A){print;system("date");delete A[$2 OFS $1];next}' Input_file1  Input_file2

3 CC
Wed Aug 10 12:36:29 GMT 2016

#!/usr/bin/env bash

# @(#) s1       Demonstrate filter one file with contents from another, grep

# Utility functions: print-as-echo, print-line-with-visual-space, debug.
# export PATH="/usr/local/bin:/usr/bin:/bin"
LC_ALL=C ; LANG=C ; export LC_ALL LANG
pe() { for _i;do printf "%s" "$_i";done; printf "\n"; }
pl() { pe;pe "-----" ;pe "$*"; }
db() { ( printf " db, ";for _i;do printf "%s" "$_i";done;printf "\n" ) >&2 ; }
db() { : ; }
C=$HOME/bin/context && [ -f $C ] && $C awk tee grep

FILE=${1-data1}

pl " Input data file $FILE:"
cat $FILE

pl " Input file data2:"
cat data2

pl " Amended input data file data3:"
awk '{ print $2,$1}' data2 |
tee data3

rm -f data4
pl " Results, filter data1, selecting data3 contents:"
grep -f data3 data1 |
tee data4
# rm -f data4   # test when grep does not create a file
pe
if [ -s data4 ] # true if file exists and size > 0
then
  while read line       # do some command for each filtered line
  do
    pe " Do your command here with line \"$line\""
  done < data4
else
  pe " No lines selected."
fi

exit 0

$ ./s1

Environment: LC_ALL = C, LANG = C
(Versions displayed with local utility "version")
OS, ker|rel, machine: Linux, 3.16.0-4-amd64, x86_64
Distribution        : Debian 8.4 (jessie) 
bash GNU bash 4.3.30
awk GNU Awk 4.1.1, API: 1.1 (GNU MPFR 3.1.2-p3, GNU MP 6.0.0)
tee (GNU coreutils) 8.23
grep (GNU grep) 2.20

-----
 Input data file data1:
AA 3
BB 1
CC 3
DD 6
EE 2
FF 6

-----
 Input file data2:
1 EE
3 CC
2 AA
12 AF

-----
 Amended input data file data3:
EE 1
CC 3
AA 2
AF 12

-----
 Results, filter data1, selecting data3 contents:
CC 3

 Do your command here with line "CC 3"