Reading CSV text files

[erock24]

I have this code that will read data from a csv file and put it in my excel sheet. However, could the code do 2 more things (listed in priority)?? 1. Start reading the file at the 3rd line, and only read every other line after that and 2. parse the data into separate columns based on the comma delimeter. I read somewhere that you could read the data into an array then loop the array into the columns to delimit it, but i don't know how to do that. Here is the code....thank you!!!!

Please Login or Register  to view this content.

[pike]

I would do it this way

Please Login or Register  to view this content.

[tony h]

I think this approach is easier for a novice to understand.
Note the texttocolumns function can be used manually from the spreadsheet

The textToColumns can be preset to state what sort of data is in which columns. I have left this on automatic. If it causes a problem you will need to post some data and I (or somone) will help you with that.

Please Login or Register  to view this content.

[erock24]

Thankyou...Pikes example worked well, I incorporated the comma delimit aspect of tony h's example. Follow up question, How can you read just the last line of a file?

[tony h]

It depends on what and why you are trying to do it.

The simplest way is to use the same code as below to read through the file and just keep the last value.
The fastest way is more complicated. You open the file in block mode and read and interpret the last blocks. It helps to know what the maximum line length is. Because of the variations this is more complex to programme.

Note: if you are just trying to keep the last line of a file you are reading anyway the code below can be altered to make this available.

[pike]

Yep thats why I use the collection you can use the data again
Just go to the last value in the collection

[shg]

That might be a lot of data to store, Pike, unless you have good reason to store it.

[pike]

True, I usually extract all the good stuff , do the calx and just store the results