Search Results

Sorry, I meant o, but options vary between versions tar xof tarfile

while(<DATA>){
my @tmp = split('"',$_,5);
if(not exists $hash{$tmp[3]}){
$hash{$tmp[3]}=1;
print;
}
else{
if($hash{$tmp[3]}<2){
$hash{$tmp[3]}++;
print;
}
}...

Yes,
it should work.

awk -F\" '
count[$4]++ < n {
if ($6 ~ /^(SQL|SELECT)/)
$6 = $6 ~ /^SQL/ ? "SQL" : "SELECT"
else
$6 = "NULL"
print
}' OFS=\" n=2 infile