Shell Programming and Scripting

Hi,

I have a file of data, each line corresponds to a case, and there are two different type of cases.

cases of type 0 have a 0 in the 2nd column and only have 3 entries
cases of type 2 have a 2 in the 2nd column and have 21 entries

i would like to be able to split the two different cases into two different file. i.e. send all lines with a 0 in column 2 to one file and all with a 2 in column 2 to a different file.

Just searching for 0 or 2 won't work as there are lots in the file and i don't know how to specifically look in a certain column...

What is the easiest way to split up this file

Thanks!

a sample file, pls!
pls use vB Codes when posting code/samples.

ok so a sample file would be

1 2 5 78 352 9804 8319 657 82 ... (21 columns of data)
2 2 1 54 692 6671 2391 2621 298 ... (21 columns of data)
3 0 2
4 2 1 67 3209 1827 37 1782 0922 873 .... (21 columns of data)
5 0 4
6 2 5 387 98 6271 278 763 7990 2635.... (21 columns of data)

and i want to split it so that lines 1, 2, 4 and 6 go into one file and lines 3 and 5 go into a different one.

cheers!

Code:

awk 'NF==21{print $0 > "21cols.txt"}
     NF==3{print $0 > "3cols.txt" }' file

Code:

nawk -v case0='case0.txt' -v caseOther='case2.txt' '{print > (($2==0) ? case0 : caseOther)}'

Code:

egrep '^[^ ]*( [^ ]*){20}$' file >onecase
egrep '^[^ ]*( [^ ]*){2}$' file >othercase

If you know you only have one or the other then you can save some typing and use the same regex, with and without -v.

Code:

egrep -v '^[^ ]*( [^ ]*){2}$' file >onecase
egrep '^[^ ]*( [^ ]*){2}$' file >othercase