Excel reading entire file, not one line at a time

[verdugan]

Hello. Me again :-)
I want to read in a space delimited file and to put each line in one cell starting with cell B2 (I will take care of splitting it into columns later). However, rather than reading one line at a time, it reads in the entire txt file at the first pass.

--------------------------------------------------------------
Unit Raw Reviewed UnReviewed.
--------------------------------------------------------------
au_io_wrapper 6 0 6
(bunch of lines deleted for readibility)
cpt_flat 51 0 51
--------------------------------------------------------------
Total 5905 0 5905
--------------------------------------------------------------

Please Login or Register  to view this content.

The code executes once and puts the entire file (200+ lines) in cell B2.

Any help is much appreciated.

Angel

[rylo]

Angel

You are not incrementing i as you pass through. Put in the line

Please Login or Register  to view this content.

before the loop statement.

rylo

[verdugan]

Rylo,

Good catch. I have increased the value of i. However, that has not solved the problem.

The very first time that the statement to read the line is executed (Line Input ...), strLine contains the entire file, not just one line. And the cell contains the entire file.

So the second time the loop doesn't execute because it's at EOF.

I've attached the data file I'm reading in case it helps.

Thanks again.

Angel

[rylo]

Hi

there seems to be a lf but no cr at the end of each row. Fiddled a bit and came up with this.

Please Login or Register  to view this content.

You will have to edit for the file location, and you may want to not clear out column A as well as B. I just did this so you can see what the full string looks like, and the broken output goes into column B.

Not sure how you are going to split it from here as there is no consistency between the ID and the first number...


rylo

[Kenneth Hobson]

If the file is not too big, one can read the data like this:

Please Login or Register  to view this content.

[verdugan]

Thank you for the answers.

I wasn't familiar with the Split function, but that's exactly what I needed.

I am impressed with the knowledge and helpfulness of this forum.

Happy Holidays,

Angel