Splitting file into multiple files

[Paul73]

Hi everyone,

I have a file that needs to be split into multiple files. A code determines when the split will occur. The problem I'm having is the number of different codes varies each time I'll run the program. For example, one time the file may look like this:

Code1, Name, address, city st zip
Code2, Name, address, city st zip
Code3, Name, address, city st zip

So this file would need three output files. The next file may look like this:

Code1, Name, address, city st zip
Code2, Name, address, city st zip
Code3, Name, address, city st zip
Code4, Name, address, city st zip
Code5, Name, address, city st zip

So this file would need five output files.

Does anyone know how to code this? If it was a set number of output files each time it wouldn't be hard for me. But having a variable number of output files is causing me trouble. Any help is greatly appreciated.

Paul

[tlhintoq]

Maybe we need to see the code you have so far.

But basically you read the one file
Loop for each line read in.
Get the code in that line
Append that line to the file for that line.
end loop

[Paul73]

Hi tlhintoq,

Thanks for your response. Sadly, I don't have any code. I'm flat-out stuck on this. How could you append to multiple files, each with different filenames? That's what's really confusing me.

[tlhintoq]

Make a text file of the code name...
code1.txt
code2.txt
etc.

When you read a line you get the code: 'code1'
That tells you the name of the file to append to.
append to code1.txt

Reading this might help

http://msdn.microsoft.com/en-us/library/3zc0w663.aspx

[Paul73]

That is helpful. Thanks!