UNIX for Beginners Questions & Answers

awk '
                {VT = $NF                                                       # Extract last field into Value Temp variable 
                 sub (FS "*" VT "$", _)                                         # and eliminate from input line
                }
NR == FNR       {VAL[$0] = VT                                                   # for the first file (NR == FNR), store the Temp into
                                                                                # VAL array indexed by curtailed input line
                 next                                                           # stop processing this input line, continue with next input line
                }
                                                                                # we're in file2 now
                {for (v in VAL)                                                 # run through all indices (= $0 from file1) of VAL array
                                 if ($0 ~ v)                                    # if actual line ($0) matches index from file1 
                                                if (VT < VAL[v])                # and actual Value Temp is less than former 
                                                                        print $0, VT, FILENAME
                                                else                            # greater than or equal
                                                                        print v, VAL[v], ARGV[1]
                }
' file[12]

if ($0 ~ v)           # if actual line ($0) matches index from file1