awk -F, '               {FN=$1"_a.txt"
                         NN=split ($NF, NAMES, ";")
                         getline X < $2; print X > FN
                         while (getline X < $3) for (i=1; i<=NN; i++) if (match (X, NAMES[i]".*"$1)) print X > FN
                         while (getline X < $2)  print X > FN
                        }
        ' controlfile
record
apurva is girl
pushpa is girl
sneha is girl
he is good
he is bad
end