UNIX for Beginners Questions & Answers

PLEASE start becoming exact and consistent when posting your problems here, also across posts, making samples match what you say in the text.
People (not only) in here tend to refer to the samples if the text is not too clear...
Also, stick to lower or upper case syntax as, in *nix, these are not equivalent: "FILE2" != "file2"!
For example, your for i in *.txt won't match ANY of your "FILE1..." names in post#7.




We don't print to stdout, but redirect it to a filename composed of the original name (which awk provides in the FILENAME variable) and the ".pruned" extension (pls be aware that *nix doesn't have the concept of file name "extensions").

That's shell's file name globbing: match any char EXCEPT "2" in the directory's entries. c.f. man bash




Try the above script like

Code:

awk ' ... ' FILE2.txt FILE1*.tab

or even drop the FILE1 part.

you might/will run out of the opened file descriptors.
Here's a slight variation on the theme:

Code:

awk '
FNR==NR         {f21[$1]=$3
                 f22[$2]=$3
                 next
                }
FNR==1        { if(fout) close(fout); fout=(FILENAME ".pruned") }
$1 in f21       { print $0, f21[$1] > fout; next }
$1 in f22       { print $0, f22[$1] > fout }
' FILE2.txt FILE1*.tab