Edit a Record in a CSV/txt File Java

[@qkloh6804]

A video that can help me after 2 years now and more years to come to help others. Great work.

[@matthewkarloski4775]

For people having to edit this file more than once, doing it with pw.println(...) causes the ending of each line to have " ". Meaning that whenever you go through it again, your last element on that line will have a " " at the end, causing a new line to appear, and also causing errors if you're trying to use that variable as something besides a string, like a int. In this case, age would be "36 ", "23 ", or whatever you gave age, instead of just the number. There's a simple solution however. Simply use pw.print(... + " "). This eliminates the " " and solves all the problems I listed above. So if we're using the example from the video, it'd be: pw.print(ID + "," + name + "," + age + " ");

[@oFancys]

ooh, merci!

[@fangzsx0409]

May 14 2020, your tutorials are very informative and on point. This is the only tutorial that worked for me. Thanks Max

[@ishanvarshney9054]

OMG ,I can't believe such a great video has only 15 likes! and this wonderful channel has only 99 subscribers. Keep going, I am sure u would cross 1M subscribers one day.

[@maxodidily]

Thanks a lot, Ishan. You will have no idea how much it means to me hearing those words. Also, we are now at 100 subs now so we just need to cube that number to get to one million now. I hope you stay tuned for more!

[@m7mdabohashem]

it's 370 likes now

[@user-mw1qb5kd9l]

he's not that close yet, but surely someday...

[@SachinPatil-vj1hu]

@@maxodidily 3000 Subs now!

[@xes2318]

he seems to get a lot of views now

[@thomas.l5924]

Thank you very much you save my life :D .

[@mohsenmcqueen]

Thx man, from iran with love :) whish you the best

[@maxodidily]

Your words make my day! I wish you the best too.

[@manjunathmali5310]

Really helpful bro thanks a lot ....

[@mamlesksiddharth]

Hey Max! This is such an awesome video! I just wanted to know if it was possible to edit just a single cell rather than changing the entire row each time I want to edit. Thanks!!!

[@NTChannel127]

thanks so much for sharing, it's really useful

[@Jacksons_are_jackson]

Thanks dude. U da best

[@TiMCoop3r]

what would be your solution if one of the items( x.next()) is a double but the rest are a string?

[@TAIGZZZZ]

it runs but but it doesnt delete the temp file and doesnt update file

[@tuantng425]

I have troubles deleting the old file and renaming the new file as File.delete() and File.renameTo() are ignored. The code works GREAT (THANK YOU SO MUCH!) but it does not delete or rename the file. Again, thank you for your helpful videos!

[@TAIGZZZZ]

same problem here

[@jeisonfonseca4030]

Did you know how to solving?

[@mohammedf.sammour8318]

Thank you very much for this good, beautiful professional work

[@maxodidily]

Your kind words have made my day.

[@mohammedf.sammour8318]

@@maxodidily It is my pleasure to thank everyone who teaches and helps people .. I wish you happy times

[@shoot-em-up895]

You are great man

[@junkai6877]

Hi there, may I ask why mine will keep adding a blank line in eachline?

[@iloveyoueggegg]

How do you stop it from starting a new line in the text file after you've written what you've written?

[@-0-__-0-]

Having issues with file.delete() returning false. Any way to fix it?

[@Total_FootballYT]

Hi mate, I’m getting NoSuchElementException with this and can’t figure out why, any ideas?

[@devishamishra7279]

How to keep the alignment same as old file..plz answer

[@adolfjamesurian6510]

What if i want to append something in a line of records?

[@rajojyoti]

Hi Max, This is a awesome video. I have one ques? How can I use for a csv file and not a text file

[@maxodidily]

Change the filename from "filename.txt" to "filename.csv".

[@rajojyoti]

@@maxodidily Thanks max. I will try and will let you know. Anyways, the session was very helpfull to me. Thanks man

[@Sheoranhe]

Is it possible without changing? i mean can't we directly edit the csv file? I am looking to add a new record in an already existing csv file.

[@sirtroy]

ARE YOU DRUNK?! But thanks, I learned

[@pushkargoyal4278]

nyc explanation

[@parmjitgill592]

Hi Max, great video. I'm just having a little trouble when the program loops through the code to find and edit the desired values. It finds and changes the values fine but the program doesn't write the remaining values in the file (the other rows)

[@Sheoranhe]

I am looking to add a new record in an already existing csv file what will be the logic ? And Input from console.

[@SebgasFlowx3]

Hey man, great video, i followed everything in order to do my code, but since im using a csv file, somehow the file is not being deleted nor changed, i don't know if the swing affects something. the temp.csv is being created correctly but the old file isn't being deleted and the temp isn't being renamed, i don't know if you will ever read this but yolo. Thanks for the video

[@marisolbeltrandelrio9760]

same.

[@yq5687]

i cannot delete the file when export file and import file

[@tingkoydesu1837]

File.renameTo() and file.delete() is not working for meee

[@amannazarri5182]

same here. so how to solve? any ideas?

[@Johncena-bk1lg]

You deserve my sub!!!

[@maxodidily]

Ty, it feels good knowing I earnt a subscription!

[@alainsoral7314]

Hello, it the thumbs up guy again. I have a question, isn't this ressources consuming if it a dictionary file for example ? not to mention if the file is also constantly modified by other methods !?

[@maxodidily]

Good question, so yes, this can be resource demanding if used in a big database system. For small databases, this is fine. This tutorial was aimed at A-Level students and this is enough for A Levels. If I were to code a bigger database I would use hashing. I shall be covering this in the near future.

[@alainsoral7314]

@@maxodidily thank you, looking forward for the hashing tutorial. keep the good work

[@8-bitJoe]

Hi, everything seems to run fine except every time I run the program, it keeps creating a new line empty space on the file. I've copied your code and it's still happening? Do you know what's causing this? Thanks.

[@brentgallagher3603]

if(item.equals(editID)) { pw.print(newID + "," + newName + "," + newAge + " "); } else { pw.print(ID+ "," + name + "," + age + " "); } use pw.print not pw.println and add a " " in the print statement...Answer is above

[@rickywong9525]

@@brentgallagher3603 Oh my gosh, thanks!! Was looking for the solution to this problem, and your answer helps me!

[@catalinsas2390]

my file is not deleted and the updated data remains in temp fil....could u please help????

[@aj_hackercat]

wait, why would you make a temporary file when you could just add the stuff to A string array? that way it would be a lot easier...

[@maxodidily]

You can use an Array if you like. I used a temp file as I wanted to keep this video in line with the WJEC Computer Science A-Level syllabus where the theory states a temp file is created, the old file is deleted and the temp file is renamed to the original file.

[@mrthaw4962]

If i do not close all my filereader and filewriter will that stop the file from deleting and renaming ?

[@maxodidily]

I'll be honest, I'm not 100% sure on that, I just close everything as it is good practice and reduces resources used. Maybe try your code but without closing the filereader and filewriter. I'm sorry I couldn't give u an answer to this good question.

[@НикифорБогданов]

Nevermind. Nice video!

[@maxodidily]

Could you send me your code via hastebin?

[@НикифорБогданов]

@@maxodidily I wrote the data without comas so it didn't write anything

[@maxodidily]

​@@НикифорБогданов I'm glad you resolved your issue!

[@Sheoranhe]

I am looking to add a new record in an already existing csv file what will be the logic ? And Input from console.

[@maxodidily]

This tutorial will show you how to add a record to a csv file: kzbin.info/www/bejne/oqGTqYSOiqqqY80 As for getting input, use the Java Scanner class and assign input it receives to a string.

[@bellthomas537]

simple i love it

[@maxodidily]

Thanks for the positive feedback!

[@MrEvmk]

Hi Max O'Didily , If I created a CSV file how to create header for that CSV.

[@maxodidily]

Just add a record to the top of the file which just consists of headers fur your fields.

[@data_science_uzbekistan]

Thanks !

[@gerhardkotze5934]

This is great code, but my problem is I can't just use Strings. What if you use different data types?

[@mmarvinn__]

Does this work with ";" instead of "," too?

[@shoot-em-up895]

Thank you very much

[@syamhans12]

Max, help me.. The old file not deleting , therefore at the end of the project i have 2 different file exist

[@maxodidily]

Could you send me your code via hastebin or pastebin please.

[@YourDhiraj]

SIr, i wrote the code but not working properly. No error message is being displayed. if you don't mind, could you give me any suggestion.

[@maxodidily]

Could you send the code via hastebin or pastebin please

[@kylemital689]

I tried the code, but instead of setting the new information to a set amount, I made a scanner that allowed the user to input what they want to change and then that was inputed into the newID for example. It doesn't work. Any help?

[@maxodidily]

Could you send me the code via hastebin or pastebin please?

[@Sheoranhe]

I am looking to add a new record in an already existing csv file what will be the logic ? And also Input should be from console.

[@yazeedmizu3184]

That's what I tried to do but did not work. Do you still have your coding for it?

[@ayanc13]

Using a windows and linux machine both, this code works for me in linux perfectly. but in windows the file does not delete at any condition!! :( can you teach me any other method?

[@maxodidily]

Firstly, I am really happy that the code works on Linux and am sorry it isn't working on Windows. Here is something you may want to have a look at, it aims to accomplish a similar thing: stackoverflow.com/questions/20039980/java-replace-line-in-text-file Also may I see the code so I can see if it works on my Windows machine?

[@abhishekjha6487]

for windows try to use java.nio.file.Files.delete(oldfile.toPath());

[@魅力之王]

the link is not available, plz update

[@seihaly8375]

Hello,I have follow your code and i have problem with update data. When i update it.The "oldFile" not delete and "Temp file" is also not rename too. Can you guide me please?. Thanks.

[@syamhans12]

same.

[@ahmednasif5443]

Same here

[@Sheoranhe]

I am looking to add a new record in an already existing csv file what will be the logic ? And Input from console.

[@internettboii_]

Nice video bro, help me a Lot. How can I copy from text file to object type arraylist? Like 1223,Bilton,23 to 1223 Billton 23

[@Gerrieberrie76]

You go through the txt file, putting every line in a String (use a String[ ] for that), and then use the String.split( " , " ) to split the lines at the comma.

[@ritikarao1662]

sir, thsi code is working gud for txt bt i gotta edit the csv file ..it shows no changes in that..please help

[@maxodidily]

There should be no issues with this code being used on a .csv file. Could you send your code via hastebin, please?

[@Sheoranhe]

I am looking to add a new record in an already existing csv file what will be the logic ? And Input should be from console.

[@igrey9616]

why do we use this as delimiter [, ] i don't understand that concept

[@maxodidily]

The comma is because we want every field to be separated by a comma, we also use as that means a new line.

[@mahinzafar4545]

could this code work in an android application in android studio

[@maxodidily]

Indeed it can.

[@adityaprerepa7656]

Dont you need to do Scanner x = new Scanner(new File(filepath));

[@maxodidily]

That way also works just as well.

[@jackpang9909]

Thanks bro, it is useful. But can i know why the rename and delete function are not working by using the same code with you? the main issue is cannot delete or rename the Main text file. So temporary file will not replace the Main file.

[@yapkarman7431]

do u found solution for this? I'm having the same problem. data is copied to temp.txt but didn't rename to records.txt

[@maxodidily]

Could you send your code via hastebin?

[@jackpang9909]

Thank you very much for replying my comment But i found a way which is overwrite the original file from temporary file by using the same method above It should be work also

[@maxodidily]

@@jackpang9909 I'm glad you have resolved the issue. If you have any other issues, don't hesitate to ask about it!

[@isore3090]

@@maxodidily hello bro, im havinf the same problem as JACK PANG and i couldnt find a solution. Can you help me with it?

[@roselynw1872]

what if you only want to change the name and the rest are the same? :(

[@maxodidily]

If you only want to change one field, you could do 'pw.println(ID + "," + newName + "," + age);' Basically, if you ever want to keep something the same you just re-write the value that existed in the original file.

[@kevinpaulsen6103]

Curly brackets don’t go on a new line, and there’s always a space after a comma.

[@meep1543]

but they do though

[@kevinpaulsen6103]

meep not according to official java style. If you put them on a new line at a good college, you’d get points marked off. Java has a code style, you can’t change it with you bad habits.

[@practifruta7330]

gracias amigo

[@killerzero8516]

why is it printing unorganized

[@dariusboteand7722]

FileWriter(blablabla) is underlined in red... only solution proposed: create a new class FileWriter... why?

[@maxodidily]

Could you send me your code via hastebin or pastebin please?

[@ujjawalyadav574]

Sir nosuchelementexception occur why

[@maxodidily]

Could you send your code via hastebin or pastebin please

[@soumyabej5770]

@@maxodidily sir we don't know how to use

[@maxodidily]

Paste your code into the giant text box here: pastebin.com/ After that, click the 'create new paste' button. After your are loaded to a new page, copy what is in the url bar on your web browser and paste the link wherever you wish to share your pastebin link.

[@soumyabej5770]

@@maxodidily ok sir

[@soumyabej5770]

@@maxodidily pastebin.com/zRSLwavW here it is sir

[@waltermonteiro7078]

if your editTerm is the age it will not change the record

[@maxodidily]

Could you send your code via hastebin please?

[@waltermonteiro7078]

problem solved sorry for bothering

[@maxodidily]

No problem, it's never a bother if anyone asks a question. May I ask how you resolved your issue?

[@sithchanrady8125]

good

[@sushomamondal6950]

Sir after running this code in my system it is showing error..... i can't understand what is the Exact problem....Sir plzz tell me the solution. Thanks in advance.

[@maxodidily]

What is the error message you are receiving?

[@sushomamondal6950]

@@maxodidily Actually sir catch block is executing...And it is printing error.

[@maxodidily]

Could you send me your code please?

[@Sheoranhe]

I am looking to add a new record in an already existing csv file what will be the logic ? And Input should be from console.

[@suswee_8189]

thanks

[@matthewsilverberg6618]

WOW

[@maxodidily]

Incredible!

[@muzilhassan2542]

this is not working

[@maxodidily]

What issue are you having?

[@dariusboteand7722]

also code doesn't work :")

[@maxodidily]

What issue have you encountered?

[@jimmyinnocent9884]

CAN SOMEONE PLEASE HELP, I DID EXACTLY AS THE VIDEO BUT IT SHOWS java.util.NoSuchElementException BTW GREAT VIDEOS MAN, HELPED ALOT public static void editRecord(String filepath, String editTerm, String newFname, String newSname, String newEmail,String newAddress, String newPhone) { String tempFile = "temp.txt"; File oldFile = new File(filepath); File newFile = new File(tempFile); String fname = ""; String sname = ""; String email = ""; String address = ""; String phone = ""; try{ FileWriter fw = new FileWriter(tempFile, true); BufferedWriter bw = new BufferedWriter(fw); PrintWriter pw = new PrintWriter(bw); x = new Scanner(new File(filepath)); x.useDelimiter("[\t ]"); while(x.hasNext()){ fname = x.next(); sname = x.next(); email = x.next(); address = x.next(); phone = x.next(); if(fname.equals(editTerm)){ pw.println(newFname + "\t" + newSname + "\t" + newEmail + "\t" + newAddress + "\t" + newPhone); }else{ pw.println(fname + "\t" + sname + "\t" + email + "\t" + address + "\t" + phone); } } x.close(); pw.flush(); pw.close(); oldFile.delete(); File dump = new File(filepath); newFile.renameTo(dump); }catch(Exception e){ System.out.println(e); } }