Search Results

much appreciated. thanks again.

it worked great and fast! But instead of !p, I used p==0. Do you see any nasty side effects of doing that workaround?

I tried single and double quotes around the entire awk statement and they both returned the same error. Should I put the quotes elsewhere?

here is the code I tried:

awk...

hmm..it's interesting but it is bringing up a syntax error but doesnt say exactly... I cut and paste directly. Any thoughts?

Thanks

---------- Post updated at 03:56 PM ---------- Previous...

it most definitely works!
what I understand from the code is that you are creating an array that puts all of the serial numbers together and then testing each line of the array as a pattern in all...

thanks for the speedy reply. I understand each individual element in your code, but since I'm not sure what it is "saying", I'm not sure how to set this up for my data....can you elaborate briefly...

1. large datafiles to be queried called "file.dat*" (column one is serial number, others are data)


file.dat1

rs10001 900 900 100 100
rs10002 800 300 200 100

file.dat2
rs10003 222 111...

Greetings,

I have about 3000 files that I want to search. The first column in all of these 3000 files has a unique serial number on each line. The subsequent columns have lots of data.
I have...