How to implement a simple command/code for multiple files?

I have been extracting a row, based on multiple key word from a xls/csv file, by using the following command. I have to implement the same for multiple xls/csv files, therefore please help me to do the same.

awk '
{ tbp=0
  if ($0 ~ keyword1 && k1 == 0) { tbp=1; k1++ }
  if ($0 ~ keyword2 && k2 == 0) { tbp=1; k2++ }
  if ($0 ~ keyword3 && k3 == 0) { tbp=1; k3++ }
  if (tbp == 1) { print }
  if ( k1+k2+k3 >=3 ) exit
 }' keyword1="avrbs2" keyword2="avrbs2" keyword3="xop" 119.csv

Thanks in advance:)

for file in /Dir/Dir1/*.csv
do
awk ' $0 ~ keyword1"|"keyword2"|"keyword3 && k++<3; k==3{exit} ' keyword1="avrbs2" keyword2="avrbs2" keyword3="xop"  $file
done
1 Like

Why not

awk '... ' *.csv
1 Like