UNIX for Dummies Questions & Answers

 
    ABC1    1    3    4
    ABC2    4    3    3
    ABC3    3    2    3
    ABC4    3    3    3

    text1   ABC1AB   text2   text3
    text2   ABC2AB   text1   
    text3   ABC1CDE   text2
    text4   ABC5AB   text3   text4

    text1   ABC1AB   text2   text3    1    3    4
    text2   ABC2AB   text1    4    3    3
    text3   ABC1CDE   text2    1    3    4
    text4   ABC5AB   text3   text4

$ awk -F"\t" 'FNR==NR{a[$1]=$2"\t"$3"\t"$4} FNR!=NR{$0=$0"\t"a[$3];print}' file1 file2 > file3

awk '
FNR==NR         {X=$1
                 sub ($1 FS, "")
                 T[X]=$0
                 next
                }
                {for (t in T) if ($2 ~ t) $(NF+1)=T[t]}
1
' FS="\t" OFS="\t" file1 file2
text1   ABC1AB  text2   text3   1       3       4
text2   ABC2AB  text1           4       3       3
text3   ABC1CDE text2   1       3       4
text4   ABC5AB  text3   text4

 {for (t in T) if ($2 ~ t) $(NF+1)=T[t]}
1

 {print $0, T[substr($2,1,4)]}