Breaking a large file into multiple file based on first two columns 2

[hill007]

I want to break a large file into multiple file based on first two columns:
For example my file is as follows:



87.73,49.62,-45.000000,0,-261581.000000,0.000000,1,1
87.73,49.62,-45.000000,0,-261581.000000,0.000000,2,2
87.73,49.62,-45.000000,0,-261581.000000,0.000000,3,3
87.74,49.63,-45.000000,0,-261581.000000,0.000000,4,4
87.74,49.63,-45.000000,0,-261581.000000,0.000000,5,5
87.74,49.63,-45.000000,0,-261581.000000,0.000000,6,6
87.74,49.63,-45.000000,0,-261581.000000,0.000000,7,7

The Final results should look like:

File 1
87.73,49.62,-45.000000,0,-261581.000000,0.000000,1,1
87.73,49.62,-45.000000,0,-261581.000000,0.000000,2,2
87.73,49.62,-45.000000,0,-261581.000000,0.000000,3,3

File 2
87.74,49.63,-45.000000,0,-261581.000000,0.000000,4,4
87.74,49.63,-45.000000,0,-261581.000000,0.000000,5,5
87.74,49.63,-45.000000,0,-261581.000000,0.000000,6,6
87.74,49.63,-45.000000,0,-261581.000000,0.000000,7,7

Any help will be appreciated.

Thanks.

 

[vgersh99]

[not tested]

nawk -f hill.awk myFile.txt

{
   idx= $1 SUBSEP $2
   if ( !(idx in arr) )
      arr[idx] = ++cnt;
   outFile= File arr[idx];
   print $0 >> outFile;
}

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[futurelet]

Tested (assumes input is sorted on first 2 columns).

BEGIN { FS="," }

f1 != $1 FS $2 {
  if (length($1))
  { f1 = $1 FS $2
    close( filename )
    count++
    filename=sprintf( "outf%05d", count)
  }
}

{ print  >filename }