Shell Programming and Scripting

$ cat file1
Milestone1
Milestone2
Milestone3
Milestone4
Milestone5
Milestone6
$ cat file2
Milestone1
Milestone12
Milestone13
Milestone14
Milestone5
Milestone16
$ grep -xFf file1 file2
Milestone1
Milestone5
$ awk 'NR==FNR{A[$1]; next}$1 in A' file1 file2
Milestone1
Milestone5

sort filename1 -o filename1

sort filename2 -o filename2

comm -12 filename1 filename2

$cat File1
Milestone1
Milestone1
Milestone2
Milestone3
Milestone4
Milestone5
Milestone6

$cat File2
Milestone1
Milestone12
Milestone13
Milestone14
Milestone5
Milestone1
Milestone16

File2:Milestone1
File2:Milestone1
File2:Milestone5

File2:Milestone1 , repeated 2 times
File2:Milestone5 , repeated 1 times

grep -xFf file1 file2 | sort -u

awk 'NR==FNR{A[$1]; next}$1 in A' file1 file2 | sort -u

awk 'NR==FNR{A[$1]++; next}$1 in A{delete A[$1]; print $1}' file1 file2

grep -HxFf file1 file2 | sort | uniq -c

echo | grep -xFf infile1904 infile1904b - | sort | uniq -c

awk '
  NR==FNR{
    A[$1]++;
    next
  }
  $1 in A{
    T[$1]++
  } 
  END{
    for(i in T)printf "%s: %s , repeated %d times\n", FILENAME,i,T[i]
  }
' file1 file2

dos2unix file1 file1
dos2unix file2 file2

awk 'NR==FNR {A[$1]; next} $1 in A {count++; print} END {print count,"matching records"}' file1 file2 > file3