I'm working on a rather irritating problem, and was hoping someone might have gone through something similar.
I'm trying to convert a massive amount of microsoft excel data into a format easy to read for Flash AS3, with
some manipulation required. So I figured I'd write a very simple parser in Java taking in a .csv file, make the
necessary little tweaks on the way and I'd be done.
What a fool I was! After almost 4 hours of errors I've run into I'm wondering if it wouldn't be faster to do it manually.
It's essentially working now, thank heavens but I've hit one massive problem that has got me completely perplexed,
and wondering if there's something strange going on with my data or I'm not realizing how to use the Scanner properly.
After about cell 40, the scanner completely fails to recognize any more of the many hundreds of cells after that line. I
thought it might be because it has a limited buffer or something so I cut down the file size but after that line it's as
though the file is invisible- the scanner opens fine, no IO exception but the second you call readLine command I get
a NoSuchElementException, informing me that the file I provided must be completely empty. I do this and open up
the file with thousands more lines to read and scratch my head in confusion.
I won't worry with a code sample because it really seems more like a data problem- really it's just opening the file
and reading it using a scanner, which we all know how to do. Has anyone ever tried parsing large files with a scanner
and hit this problem, and if so can you suggest a solution?
Thanks a lot for reading, and I'd be very appreciative of a response. There's no mad rush to solve the problem, I can
use the 40 lines I have now to demonstrate the core of the program is working, but I will need those other lines
eventually and I really don't want to manipulate them by hand, especially if there's more coming!