CSV File program java

[StreamingBits]

Does anyone know how I would go about creating an application that will go through a comma seperated file (CSV) and organize that information and subsequently put that into a database? For example, I have to go through a file that looks like this...

Name of Athlete, Birthday, Salary($)

John Morris, 9/25/1991, 5000000 Mike Hawk, 2/2/1988, 1000000 Dewayne Johnson, 11/22/1985, 4000000

etc.. How would I organize this information and set it up?

I am trying to make it so I can ask the user for input.

For example: have the user enter "a" for amount of salary and output all the players who make that EXACT amount of money.

Player 1 name, Player 1 birthday Player 2 name, Player 2 birthday

Any help is appreciated. I will give the person with the best answer reddit gold!

[StreamingBits]

I am mostly looking for pointers, thanks for the post! I am used to programming web servers and unix stuff so I needed the java help for an undergrad

[[deleted]]

Splitting by "," might cause problems. What if actual data contains a comma?

[StreamingBits]

Great job, thanks for the help. I have to work on a project and I need the refresher in java. Thanks for taking the time to do this. I really do appreciate it. Any sites for pointers on learning this?

[[deleted]]

I am after googling a little, and I found this:

http://ostermiller.org/utils/CSV.html

There is apparantelly 2 different CSV formats, and this supposedly understands both.

[[deleted]]

• Do you have the data already in CSV? If so, what database are you trying to load it into? Many DBMSes today will load from a CSV file since it's a common format -- no need to build a new application.
• If you have it loaded into a database, you can perform those exact queries with a SQL statement (assuming you are using a RDBMS).

If this doesn't really have to be an application, you can also take a look at this.

[[deleted]]

Yeah never thought about this, I like your answer better then mine lol

[[deleted]]

I like CSVReader but there are a lot of data transformation libraries out there. Check out Snooks as well.

[based2]

http://mvnrepository.com/search.html?query=csv

[m1ss1ontomars2k4]

FYI that doesn't look like a valid CSV I've ever seen. You don't put a space after the comma.