Shell Programming and Scripting

awk -F"|" '{print $1, $2, $4, $5, $10}' File1.txt > temp1.txt

awk -F"," '{print $1, $2}' File2.txt|tr '[:lower:]' '[:upper:]'  > temp2.txt

egrep -f File2.txt File1.txt > Final.txt

awk -F"|" '{print $1, $2, $4, $5, $10}' File1.txt|tr '[:lower:]' '[:upper:]' > temp1.txt
awk -F"," '{print $1, $2}' File2.txt|tr '[:lower:]' '[:upper:]'  > temp2.txt
for MAC in `cat temp1.txt`
 do
  MAC2=`cut -d" " -f1 temp2.txt`
  IP=`cut -d" " -f2 temp2.txt`
  if [ "$MAC" = "$MAC2" ] ; then
   echo "`cat temp1.txt` - $IP" >> Final.txt
  fi
 done

nawk '
BEGIN {
  FS1="|"
  FS2=","
  FS=FS2
}
FNR==NR { a[$2]=$1;next}
FNR==1 {FS=FS1;$0=$0}
$10 in a {$0=$0 FS a[$10]; print}' file2 file1

tr '[:lower:]' '[:upper:]'

nawk '
BEGIN {
  # FieldSeparator for file1
  FS1="|"

  # FieldSeparator for file2
  FS2=","

  # start with file2 => assign the appropriate FS
  FS=FS2
}
# if processing the FIRST file (specified on cli - file2), array "a" indexed by "toupper($2)" (second field) with the value of "$1" (first field)
# "next" => go to the next record/line
FNR==NR { a[toupper($2)]=$1;next}

# if we got here - you're processing the SECOND file from cli (file1)
# if on the FIRST line (FNR==1) set the FieldSeparator (FS) to the value of FS1 "|" and reevaluate the current record ($0=$0) given a new FS
FNR==1 {FS=FS1;$0=$0}

# if the TENTH field ($10) is in array "a" (index in "a"), then print the entire record/line suffixing it with the FieldSeparator (FS) and the
# value from array "a" indexed by the TENTH field ($10).
$10 in a {print $0 FS a[$10]}' file2 file1