Filtering

Hi All,

I should take all "more*.dat" files from each "DH*" directory and to write out first 5 rows into "list" fajl. So each "DH*" directory
should have "list" falj with 5 rows from all "more*.dat" within it. This command line works this job


for dir in DH* ; do
for file in `find $dir -type f -name "more*data.dat" -print`; do
awk 'BEGIN{FS=","}{if(NR>1 && NR<7){
f=n=FILENAME;sub(/[^/]+$/,"list",f);sub(/.*\//,"",n);print
$6,$7,n>>f}}' $file
done
done


But I would NOT like to have file names in "list" that contain words "t10" or "t9". How to filter them out in this context?

Thank you
Oliver

Firstly you code will be much easier to read if you post it between 'code' tags so it preserves the layout, like this:


Awk will let you filter out lines that match a regex, so I think this will do what you want (I have also changed the formatting to make it more readable):

thans for reply

this change in the program does not the filtering job. Have an idea why?

ok. this is what I wanted....but your suggestion direct me to it

for dir in DH* ; do
for file in `find $dir -type f -name "more*data.dat" -print`; do
awk '
BEGIN{FS=","}
!/t(9|10)/ {
if(NR>1 && NR<7){
f=n=FILENAME;
sub(/[^/]+$/,"list",f);
sub(/.*\//,"",n);
if (match(n,/tau(1|2)/) == 0) print $6,$7,n>>f
}
}
' $file
done
done