File-split

[Pete]

I have a large csv file that I wish to split by state codes. File-split will do what I want,I'm think, but does the file need to be sorted by state to work?

The files has close to 200M records and I do not want to loop through it multiple times, but rather export a row to the appropriate file, if the file exists, else create the file.

Can this be done with csv fix without trying to sort the data?

Thanks

[Neil Butterworth]

To use file_split, the input file does not need to be sorted, and CSVfix will only need to make a single pass over it.

Regards,

Neil Butterworth

[ly...@southerlyengineering.com]

I just tried to spilt by the 13th column a record with about 334,000 rows. It ran for awhile but no files were created and no errors.

How do I know what is wrong?

[Neil Butterworth]

CSVfix  should  have no problems processing this file, and if it  didn't produce an error message, it probably has done so. are you sure you are looking in the right directory for the output files?