Quote:
Originally Posted by
vgersh99
is 'ec' the first field in all.inq?
Pls post a sample all.inq, a sample 1.lst and a desired output of 1.inq
And indicate a 'common' field between all.inq and 1.lst files
Alright, this is a sample from all.inq:
Quote:
570613667 6 191 compatible unpleasb 30 1 579 30 Anger
570613667 6 192 compatible europeanamericanright 76 1 490 35 g10cm.bmp
570613667 6 193 compatible unpleasb 30 1 805 49 Debt
570613667 6 194 compatible pleasb 76 1 803 3 Dinner
570613667 6 195 compatible pleasb 30 0 617 11 Merry
570613667 6 196 compatible unpleasb 30 1 638 15 Lice
570613667 6 197 compatible pleasb 76 1 595 43 Home
570613667 6 198 compatible pleasb 76 1 569 35 Yacht
570613667 6 199 compatible europeanamericanright 76 1 497 50 g28cm.bmp
570613667 6 200 compatible unpleasb 30 1 627 48 Broken
The file is enormous so this is only a small chunk of block 6 from subject# 570613667. If you look in my first post, that simplified version should be enough to work with. The experiment condition is only in one field of one record at the top of each subject (that line also begins with the subject#, which is a good thing for me). I already handled this part of the process with awk. I found a unique quality of a field in the first line, and printed the ec and sn fields ($6=ec; $1=sn, if you care).
So, my master list looks like this:
Quote:
1 72430987
1 48942358
3 95842375
2 89432754
6 94378257
8 98734193
4 74322245
...
There are no headers. $1=ec; $2=sn
In case it would be helpful, I also have made sub lists by grepping all lines that begin with 1, 2, 3, ... for all possible ec.
Ideally, I would not use these sub lists, and I would be able to read right from the master list.
My output would look exactly like the all.inq, except that the subjects with ec=1 would be in a file 1.inq, and so on. Again, the relationship is mandated by the records in the master list.
I hope this is clear enough for you to help me now! Thank you,
Chris
PS you can safely assume all spaces are tabs.