Shell Programming and Scripting

Type | Bank Code | Account | Name | Date/Time
60|ABC123|TX123456|XXXX|YYYYMMDDHH:MM:SS
72|ABC123|MYD34561|XXXX|YYYYMMDDHH:MM:SS
95|ABC345|AX672456|XXXX|YYYYMMDDHH:MM:SS
82|ABC456|PY123456|XXXX|YYYYMMDDHH:MM:SS

Bank Code | Account | Min Val | Max Val | Stream Code | Stream ID
ABC123|TX123456|0000|1111|TXY123|T1234567
ABC345|AX672456|0000|1111|TCT345|T4589561
ABC789|MM123331|0000|1111|TCB789|T1012548

Type | Stream Code | Stream ID |  Name | Date/Time

awk 'NR==FNR{A[$1,$2]=($5,$6); next} ($2,$3) in A{($2,$3)=A[$2,$3]; print}' file2 file1 > file3

awk '
NR==FNR         {A[$1,$2]=$5 "|" $6
                 next
                }
($2,$3) in A    {split (A[$2,$3], T)
                 $2=T[1]
                 $3=T[2]
                 print
                }
' FS="|" OFS="|" file2 file1

awk 'NR==FNR{A[$1,$2]=$5 FS $6; next} ($2,$3) in A{print $1, A[$2,$3], $4, $5}' FS=\| OFS=\| file2 file1

awk 'NR==FNR{A[$1,$2]=$1; next} ($2,$3) in A(print $0}' FS="|" OFS="|" file1 file2 > file3