Originally Posted by Dave Sinkula
>Perhaps I was too jumpy as well. But discovering code I wrote being posted here after it was made incorrect, and then seeing an identical thread elsewhere...
My apologies, I didn't even see that you were the one who wrote that code. Now that I step back, it seems like everywhere I've looked or posted, it had something to do with you. Strange.
Originally Posted by Dave Sinkula
>If you cross-post, that's your choice. I suggest at least updating each cross-post with links to where it is cross-posted. Otherwise someone might spend a fair amount of time trying to help, only to be handed one of those "thanks, but I got it working" [with the help from one of the cross posts].
Will do.
Originally Posted by Dave Sinkula
>But back to the original issue. What is the big picture?
Do you even need an array, or could you simply read, modify and write each value?
Is the matrix rectangular? Is the size fixed or could it vary?
Well each value will have something different applied to it. The basic formats of each row go as follows:
date, time, price, price, price, price, volume,
So it will always be 7 columns, but the number of rows will always vary.
The reason I thought I would need an array is to go about sorting the columns by date and time, though I could also do that in excel before saving the .csv file. A problem I'm dealing with is that there is more than 65,000 rows of data, so I have to use rows A-G, then move to H-N for the rest, and so on.
At that point I have to format the date from mm/dd/yyyy to yyyymmdd and the time from standard to military (which I assume won't be hard to just have done in the program as well). I then copy all of the rows into notepad where the file is then complete for my purposes and moved on to someone else.