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:)