netslt
asked on
process large csv file with java
Hi
I have csv files with just one column and maybe 1'000'000 lines, like this:
abce
sdfsdf
etwtt
sdfsffsf
(basically wordlists)
I would like to open these files with a swing form (netbeans) - i.e. i need an "open" button, after clicking it i select the file, and then the file gets processed line by line (i process the content of each line and query some mysql stuff for each line) until the end of the file is reached.
thanks for some input / sample code on how to do this!
I have csv files with just one column and maybe 1'000'000 lines, like this:
abce
sdfsdf
etwtt
sdfsffsf
(basically wordlists)
I would like to open these files with a swing form (netbeans) - i.e. i need an "open" button, after clicking it i select the file, and then the file gets processed line by line (i process the content of each line and query some mysql stuff for each line) until the end of the file is reached.
thanks for some input / sample code on how to do this!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:)
CEHJ gave you the right answer within minutes. You might not be aware that an A grade does not cost you anything, but gives more points to the expert. Plus, of course, you got the right answer, which should be graded as an A. Please consider that the next time you try to award points to the people who are helping on the site.
ASKER
Hello CEHJ and mrcoffee356
I am really sorry if I made a rating that is not the way that it should have been done.
If I could change the rating it I would (dont see any possibility to do this - if there is, pls let me know)
My thoughts were that an answer with sample code (as I asked in the question) would have been an A, and a general answer not really an A.
But of course that was not right thinking.
Also I was not sure on the distribution of points. Both answers where of help - so I distributed the points evenly.
Maybe I should have given all points to CEHJ or at least more because he was faster? Here I was just unsure and wanted to honor both efforts.
Again: I am sorry!
I am really sorry if I made a rating that is not the way that it should have been done.
If I could change the rating it I would (dont see any possibility to do this - if there is, pls let me know)
My thoughts were that an answer with sample code (as I asked in the question) would have been an A, and a general answer not really an A.
But of course that was not right thinking.
Also I was not sure on the distribution of points. Both answers where of help - so I distributed the points evenly.
Maybe I should have given all points to CEHJ or at least more because he was faster? Here I was just unsure and wanted to honor both efforts.
Again: I am sorry!
ASKER
Thanks!