Reading and parsing delimited CSV data from a file into an Object in Java

Access a file with java.io.File; read the data with java.util.Scanner and nextline(). Use the split() method to parse the file contents by a delimiter. Take the parsed contents, and insert them into an object.
This video is part of a playlist, available here: • Computer Programming 1...
The source code for this video is available on GitHub at github.com/dis...

[@Gamuss12345]

OMG your way of teaching is soooooo much better than all of the TH-camrs I've seen before! Incredible! Very very beginner-friendly! Thank you! :)

[@discospiff]

Thanks, I really appreciated your endorsement! IT skills will serve you well. Keep me updated on your journey!

[@bananaapple2253]

Since today is 30/9/2023 but the video is so usefull for me just becuase it actually help me to figure out how to done my assignment. Thank you so much for the effort

[@discospiff]

That's funny! This is an ooooooooold video. :)

[@AhmedHadiPADI_scuba_instructor]

very very professional explanation! going slowly and clear voice. love it.

[@discospiff]

Excellent! Thanks for the feedback.

[@AhmedHadiPADI_scuba_instructor]

you welcome!
what would you do if you had multiple lines of numbers? thanks!

[@michaelhutchinson213]

My first time commenting on a video, but really wanted to say thank-you, very well explained, great help

[@discospiff]

Excellent, thanks for the feedback! I'm glad I made your first time comment. :)

[@58gullu58]

What if you have multiple lines and want to create an object for each line and add them in an Array?

[@williaminfiesto2529]

This was very helpful and easy to understand. Thank you!

[@discospiff]

Thanks for the feedback! I strive to make my videos easy for a wide audience to understand, so I appreciate hearing when I've met my goal.

[@jonathanharris2326]

This was incredibly helpful for my first project in java. I'm used to C++ but i'm starting to really like java, so easy!

[@discospiff]

Glad to hear that! This is an older video in my library; I'm happy to hear it's still useful. :)

[@gabriel9668]

Thank you very much! I am working on this assignment for my class and this video helped a lot! :)

[@caseycruz7959]

Great Video! Would you be able to do this with one of the aariables as String[ ] rather then just a string?

[@lauragriffiths3332]

all i can say is THANK YOU !!!

[@discospiff]

You're welcome! I'm glad it helped.

[@mabblers]

Very good video. Do you have one like with more rows from the file?

[@discospiff]

Hmmmm. I would just put the Scanner's read method in a loop, and iterate over the file until complete.

[@fannymoryta]

Great tutorial.!

[@discospiff]

:) Thanks.

[@SB-ou5yp]

Hi Brandon, your tutorial was very useful but I've been having issues with a CSV file, particularly when printing out the cells in the last column of each row within my CSV file. It's like the last cell in the previous row is attached to the first cell in the next row of the file. The cell contents print in the correct position but they print simultaneously as if they are joined together.
For instance, let's say I have a CSV file with the contents:
7,7,7,7
3,3,3,3
When printing each number, the first three sevens in the first row print individually but the last seven prints with the first three in the next row, like so:
1st pass
7,
2nd pass
7,7,
3rd pass
7,7,7,
4th pass
7,7,7,7
3,
My program aims to store each element individually and cannot do so until I figure out how to separate the last and first lines.
Do you have any idea on how to solve this?

[@asharshahab1982]

What happens when i encounter a blank row while reading the excel.csv file? How do i skip that line whiout any run time error sir?

[@discospiff]

I'd check for the length of the row first, and decide whether or not to skip.
Or... use a try-catch block to catch an error from an empty row, and then decide how to process it.

[@frankkid010]

What if the file had multiple vehicles, let's say 5, is there a way to do this without manually creating 5 variables for the vehicles?

[@discospiff]

Use an array... ArrayList I believe I covered that in a later video.

[@frankkid010]

@@discospiff thank you

[@HazzM]

Any link or title to find this? I've looked but nothing jumped out at me

[@XSource100]

how do you read objects from csv and insert them into object class

[@safarnama04]

my program is not returning correct output for next lines, it is working for first line only

[@copieselect9846]

I used the same technique for student detail but do not know how to make that in loop and form a array of student objects

[@discospiff]

How can I help?

[@marcusdouglas332]

Lets say that one cars you made had more than one mpg value, how could you represent that on the same line?

[@discospiff]

If it's a one to many relationship, I would split the "many" side into a separate file that is foreign-keyed back to the main cars file, using a unique identifier.
Alternatively, you could do it all in one file if you have an additional field before the mpgs: a field that tells you how many MPGs follow. That way, you know how many mpgs to expect, and you read and parse each of them, then continue with the next field.

[@marcusdouglas332]

So there isn't a way to have a flexible field that could hold more than one value? Say we input the amount of cash transactions a business has in one day.

[@lennysmileyface]

I do this instead.
Have your file in myproject/eg/
new FileReader("eg/" + fileName + ".fileextension")

[@ΣΠΥΡΙΔΩΝΓΟΥΛΑΣ]

it works with .tsv files?

[@cithpo5938]

Dear Mr. Brandon, can I get your codes for study?

[@discospiff]

Sure, it's freely available on GitHub here: github.com/discospiff/US16Vehicles

[@cithpo5938]

Thank you so much

[@NazmulIslam-zc9te]

nice

[@budpatterson8357]

First