UNIX for Dummies Questions & Answers

tab1[0]="name1 surname1"
tab1[1]="name2 surname2"
tab1[2]="name3 surname3"

tab2[0]="First"
tab2[1]="Second"

"aaaaa","surname1","name1","ddddd,eeeee","ffffff","ggggg","3","2012/02/22 12:25:21","2012/02/22 00:00:00","8","hhhh","First"
"aaaaa","bbbbbb","ccccc","ddddd,eeeee","ffffff","ggggg","3","2012/02/22 12:25:21","2012/02/22 00:00:00","8","hhhh","Second"
"aaaaa","surname2","name2","ddddd,eeeee","ffffff","ggggg","3","2012/02/22 12:25:21","2012/02/22 00:00:00","8","hhhh","iiii"

> temp.file
for i in tab1.length; do
awk '$2 $3 == tab1[$i]' file >> temp.file
done
for i in tab2.length; do
awk '$12 == tab2[$i]' file >> temp.file
done

name1 surname1
name2 surname2
name3 surname3

$ cat awkarr.sh

#!/bin/sh

# Create a file full of awk code to run
cat <<EOF > /tmp/$$
BEGIN {
        # Slurp the contents of your config file into this bit of awk
        `cat conffile`

        # Get arrays into form A["name"]=1 for easy lookup later
        for(X in tab1)
        {
                split(tab1[X], A);
                for(X in A)     T1[A[X]]++;
        }

        # Add a " since the extra quotes on the first and last record
        # aren't all eaten by FS
        for(X in tab2)  T2[tab2[X]"\""]++

        FS="\",\""
}

# Dollar only needs escaping because its in a here-document
T1[\$2] && T1[\$3] && T2[\$12]

EOF

awk -f /tmp/$$ data

rm -f /tmp/$$

$ ./awkarr.sh

"aaaaa","surname1","name1","ddddd,eeeee","ffffff","ggggg","3","2012/02/22 12:25:21","2012/02/22 00:00:00","8","hhhh","First"

$