Shell Programming and Scripting

0623@1100@ABCXYZ
0624@1203@ABCXYZ
0624@1345@XYZ123
0624@1458@123456
0625@0900@123ABC
0625@0930@ABCXYZ

ABCXYZ@APPLICATION@GROUP
XYZ123@APP1@GROUP1
123456@APP45@GROUP34
123ABC@APP2@GROUP2

0623 1100 ABCXYZ APPLICATION GROUP
0624 1203 ABCXYZ APPLICATION GROUP
0624 1345 XYZ123 APP1 GROUP1
0624 1458 123456 APP45 GROUP34
0625 0900 123ABC APP2 GROUP2
0625 0930 ABCXYZ APPLICATION GROUP

awk -F@ 'NR==FNR{A[$1=$1]=$0; next} $3=A[$3]' file2 file1

awk -F@ 'NR == FNR {
  $1 = $1
  f2[$1] = $0
  next
  }
!d[$0]++ {
  print $1, $2, f2[$3]
  }' file2 file1

$ cat script.awk
BEGIN {
        ## A space as Output File Separator.
        OFS = " "

        ## Field Separator.
        FS = "@"
}

## First input file. Save data in an array, field 1 as key and
## fields 2 and 3 as values.
FNR == NR {
        f2[ $1 ] = $2 " " $3
        next
}

## Second input file. If third field is found, do a no-op to 
## use OFS and print.
FNR < NR {
        if ( f2[ $3 ] ) {
                $1 = $1
                print $0, f2[ $3 ]
        }
}
$ awk -f script.awk file2 file1
0623 1100 ABCXYZ APPLICATION GROUP
0624 1203 ABCXYZ APPLICATION GROUP
0624 1345 XYZ123 APP1 GROUP1
0624 1458 123456 APP45 GROUP34
0625 0900 123ABC APP2 GROUP2
0625 0930 ABCXYZ APPLICATION GROUP

tr -d ' '

 awk -F"@" 'NR==FNR{a[$1]=$2 " " $3; next}
{gsub(" ","",$3); if(a[$3]) { print $0 , a[$3]}}' apps2.txt notok.txt