DOS runs out of memory thus was going to see if easy VB way. Source files are 2GB each.
I have 10 source files that are ! delimited. The first row is a header row. The first column in each file is the Year column. It appears as: "2012"!"January"!
I need a script that will read every .txt file in the directory and create new files based on the column 1 value. Each new file will only contain the rows of the same year. For Example all rows that begin with "2012" will be a new file named the same as the original but prefixed with '2012'. So if the original file name was 'file.txt' new filename would be '2012file.txt' and so on. I need the header row in each new file too.