There will be approximately 11,000 groups since this is all the schools in the state of Texas. True some of the groupings will be small, but when getting into the Houston and Dallas area, they get kin ...
the number of records in each file has not been determined yet as tot he number of files. I just know that I will need to split into manageable chunks and keep the 1st 9 dig ...
I am looking at a way to split a large file (4.5 mil records) into smaller chunks say about 100,000 records each, but keep a specific grouping together.