I can't see the close in your posted code, but it sounds like that needs to be moved out of the loop as well.
Aw you are correct. Thank you. I left my close inside that loop without realizing it.
As for leaving 1 copy - well, yes, maybe. But the open/close within the loop is definitely wrong, so fix that first & see what happens.
Maybe its writing a blank/empty line in its last pass???
I do find it rather odd how it left my file modified without actually adding something to it though.
Thank you to all three of you who posted. Its always nice when one can get something working correctly. And much easier to fix problems with multiple people helping out
//for the meantime I am going to leave this unsolved to give BestJewSinceJC a chance to reply about making them into methods. I had tried this before resorting to putting it altogether and didn't have much success.
If he would like to give it a shot he can post it, if not just post saying so and I will mark it as solved.
New Questions
1.
As you can see when I split the file I give it how many columns it was have. Well I just noticed some of the new data I have doesn't always have 3, sometimes it has 2 or even 1. How can I fix this so that it doesn't …