Java read CSV File 📰

IMPORTANT NOTE: If values in your CSV contain commas naturally, they will be split. (Ex. $1,000). If this is the case, replace:
String[] row = line.split(",");
with
String[] row = line.split(",(?=([^\"]*\"[^\"]*\")*[^\"]*$)");
^ This is regex and is very complicated. It looks for string patterns. Explaining this requires another video entirely.
//******************************************************
import java.io.*;
public class Main {
public static void main(String[] args) {
//CSV = Comma-Separated Values
// text file that uses a comma to separate values
String file = "src\\students.csv";
BufferedReader reader = null;
String line = "";
try {
reader = new BufferedReader(new FileReader(file));
while((line = reader.readLine()) != null) {
String[] row = line.split(",");
//String[] row = line.split(",(?=([^\"]*\"[^\"]*\")*[^\"]*$)");
//use this if your values already contain commas
for(String index : row) {
System.out.printf("%-10s", index);
}
System.out.println();
}
}
catch(Exception e) {
e.printStackTrace();
}
finally {
try {
reader.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
//******************************************************

[@AwaidhGaming]

You helped me in each and every step of my project ...Thanks

[@Confusedcapybara8772]

Still the best coding channels on yt. love you bro

[@ignacioleonmorales7225]

Bro thanks for your video, it helps me a lot. I'm starting in java programming, so it was very usefull.

[@BroCodez]

IMPORTANT NOTE: If values in your CSV contain commas naturally, they will be split. (Ex. $1,000). If this is the case, replace: String[] row = line.split(","); with String[] row = line.split(",(?=([^\"]*\"[^\"]*\")*[^\"]*$)"); ^ This is regex and is very complicated. It looks for string patterns. Explaining this requires another video entirely. //****************************************************** import java.io.*; public class Main { public static void main(String[] args) { //CSV = Comma-Separated Values // text file that uses a comma to separate values String file = "src\\students.csv"; BufferedReader reader = null; String line = ""; try { reader = new BufferedReader(new FileReader(file)); while((line = reader.readLine()) != null) { String[] row = line.split(","); //String[] row = line.split(",(?=([^\"]*\"[^\"]*\")*[^\"]*$)"); //use this if your values already contain commas for(String index : row) { System.out.printf("%-10s", index); } System.out.println(); } } catch(Exception e) { e.printStackTrace(); } finally { try { reader.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } //******************************************************

[@anandtandon6489]

Doesn't work if there are empty cells in the csv :(

[@kafwankamunshimbwe9235]

Your video helped me out big time with my lab

[@svetlanamazhaykina6918]

Thanks for your work! Well done!

[@heavencanceller1863]

Your videos are a blessing

[@janetkalu3064]

Thank you Brocode, you rock my tech world.

[@muhammadsalah3981]

Very good and clear illustration bro ❤

[@scilesful]

any ideas about how to store values directly in a 2-Dimensional array?

[@simpleton7758]

very helpful~thank you so much.

[@palo8818]

I love your tutorials

[@honey30prachi]

Simple and helpful video.

[@lucyledezma709]

Hi!. Your videos are so useful!. Thanks for share!

[@BroCodez]

Glad you like them!

[@raqiburrahman2666]

Thank you so much... It works well

[@frozen1093]

Lol i saved it as csv but it was separated by ; and had to separat it by , manually Thanks for the tutorial!

[@Adrastus_]

I've been trying to study and practice and learn java for about a year now but it has mainly been on and off and lately I find myself with no time to practice, so I basically feel like I forgot everything I have learned and am a beginner again. This is all to say, why would one ever create a java program to read a csv file, when what was printed here is the exact same thing as the google sheets? Is it a matter of formatting that you could do with java?

[@Wadkar07]

bro u really make it easy every time, thankx for that, but one thing i want to know is what is the name of the song which u have in intro

[@t_min_o]

Bro, helpful video, thanks a ton!. can you also make how to do it using apache csv parser please ?

[@mohamedal-ziadi5640]

Very Helpful video thanks. Do you know how to convert CSV file to Java Objects?

[@user-mv4qh2jt7d]

Thank you!

[@relaxingmeditationmusic9761]

How do i start reading the file at like the 3rd row?

[@cristianbau2353]

you saved me thank you man

[@Saikumar_Miryala]

if the commma consists in between value then it fails

[@beingpeterkevin]

Thank You bro!

[@user-gi1vc5qt6p]

superb

[@ruturajpal6500]

thanks for the code and video

[@tanmaytrivedi8188]

Informative video for me actually i am a cse student and i want to read from csv and perform some operation on it and print it in pdf form . I will use concept to read from csv .

[@sabermmirza]

Thank you ❤️

[@mihailbelev]

very helpful !!!

[@Alan-pz9gf]

Appreciate the video. By any chance do you have a how to write in a csv and how to place the info in a javaTable?

[@vijayp9870]

Can you share how to write in csv

[@samsepiol7]

I have a question, I need to read 3 csv file. How can I make this ?

[@nehalayaaz9406]

Thanks 🙏

[@Nomad5915]

Thank you

[@GreenT3A_4u]

What do I do if my csv file have empty cells? How do I skip them?

[@orbmaster9815]

It worked thank you

[@hristogeorgiev6531]

Bro very helpful tutorial. But what if I need to save each column in a separate array/ArrayList? Do you have a video where you show something similar?

[@willvall7868]

do you found any solution for that problem?

[@hristogeorgiev6531]

@@willvall7868 Could you give me some more context to your problem? I found a solution but as you can see the comment was posted a year ago.

[@willvall7868]

@@hristogeorgiev6531 as you already told by yourself :) np. I found a solution by myself. But thank you for caring :D

[@hristogeorgiev6531]

@@willvall7868 The problem is I myself don't remember what I was trying to do. Glad you found a solution though!

[@omidragon15]

Good stuff

[@user-vs9cq9nm5x]

the best channel

[@barathn6239]

How to write a new data in csv file using java, bro?

[@DanielRamos-to1pd]

love you bro

[@hamitalkin9294]

can some one give me a tutorial how to safe them into an two deminsonal array?

[@eglencedostu6433]

Thanks

[@mimikrama]

ty

[@aniketchopra5061]

great

[@SeasonedChicken5]

How would you go about storing it in a 2D array?

[@zeroii-nd9dr]

i also would like to know !

[@farhanaziz1177]

Sor rows... Thw whole array become sorted

[@abirbek4315]

thank youuuuuuuu

[@NachoGalvisRuiz]

Gracias

[@anubhavsingh145]

How we can get extract data rowise

[@chaer7898]

Here bro sorry but I think I agree with guys comment.hope you can make a course on what he is saying cuz it will be great!!! Hiro code I love your videos hoping you will add java applet to your java course and we will do game development like creating adventure games and also we will do some algorithm and data structure and it will be more fun if we learn it through game development like development a sport game!!!!! thanks for video it has help me a lot......

[@BroCodez]

Well it does seem that the game tutorials have been doing well...

[@chaer7898]

Yeah so add more gaming development tutorials and aslo Java applet bro

[@MdAbdullah-qz4jp]

How can I change something from a csv file. Like I want to make some condition. if a student gets 40 then he/she will pass.

[@vijayp9870]

Can you share

[@jeljelespuerta5068]

Bro code, question, is there a way for me to read a single row only? if there is can u help me with that? thanks! more power to your channel!

[@pedroluckeroth6601]

It has been 2 yeas, have you discovered it?

[@darpyy8102]

wow!

[@stebboy]

nice

[@Mohammed-tx1ok]

What is regular expression? I see it everywhere in java and it looks very difficult. Can you make a video for regular expression

[@BroCodez]

It's a sequence of characters that define a search pattern. The one that I posted looks for commas that are not within a set of " " and splits the line. I'd like to make a video on it but I don't think I'm ready to explain it yet

[@Mohammed-tx1ok]

Bro Code alright that is fine

[@devibala6949]

Bro. How to read three different CSV files and convert it into json after mapping?

[@devibala6949]

Bro. I'm stuck on code

[@gerdsfargen6687]

OpenCSV and streams work great together though.

[@sagarpapineni7843]

Hi need your assistance

[@teenva]

❤

[@everydayartes]

Don’t work for android

[@manojseenivasan8854]

Bro do for Android development

[@kex6799]

alalalallalalala for the yt

[@jgposner]

👍

[@tong4925]

It's so funny that Snoop Dogg passed and Karen failed lmao

[@knucklechukka]

commenting per instruction

[@RaselAhmed-ix5ee]

bro i need an urgent help please reply me... i am stuck in a program please reply ASAP

[@BroCodez]

what's the problem?

[@RaselAhmed-ix5ee]

@@BroCodez i need to read some data from student record and find the mean ,average , of marks of each student and print it another file?

[@BroCodez]

what's your current code look like?

[@RaselAhmed-ix5ee]

@@BroCodez where can i send you the screenshot?

[@BroCodez]

if you can, post the code in the comments

[@sagarpapineni7843]

Hello

[@curtking8803]

Every illustrated error catching exercise should be from a Karen like karen trying to divide by zero or some logical error

[@BroCodez]

That's usually Steve's job

[@freelancepakistan424]

k

[@noah77]

Hey bro, I commented a huuuuugggggeee comment on Qazi's latest video, please see it.

[@BroCodez]

What's the link?

[@noah77]

@@BroCodez kzbin.info/www/bejne/g33Jlpqsi5xsr7s

[@augischadiegils.5109]

❤