 |  |  |  |  |  |  |  |
write and delete details on csv file in C++
 |
Hello! Please help me!!!
I have been trying to make a program that show details written on a csv file. Somehow I have managed to do so, by using a code for opening *txt files. However, I would also need to add details to the same csv file, and delete details as well. I've already learned how to sort alphabetical strings by the help of this forum, so thanks in advance!
Let's say menu says
1 Open csv file
2 add data on csv file
3 delete data on csv file
when you click on two it will ask you to enter a name. it then gets added to the csv file. i dunno, i can't explain it really clearly, but hope you can help!
thanks!
I have been trying to make a program that show details written on a csv file. Somehow I have managed to do so, by using a code for opening *txt files. However, I would also need to add details to the same csv file, and delete details as well. I've already learned how to sort alphabetical strings by the help of this forum, so thanks in advance!
Let's say menu says
1 Open csv file
2 add data on csv file
3 delete data on csv file
when you click on two it will ask you to enter a name. it then gets added to the csv file. i dunno, i can't explain it really clearly, but hope you can help!
thanks!
•
•
Join Date: May 2007
Posts: 1,839
Reputation: 
Solved Threads: 49
Don't think of a csv file as anything other than a file. You can access it and everything just like any other file (text file you mentioned).
What you want to do is not hard but it requires more than appending data. The simplest way of managing this (I reckon), is to create a vector of a vector of strings:
std::vector< std::vector<std::string> > csv_file_contents;
don't forget to #include <vector> and <string>. First thing is to read in the current file. I reckon line by line and tokenise with comas. The manipulation becomes much easier then. You can .erase() or .insert() or push back easily enough. Then save the contents of the csv file each time.
Note - this is not a good solution if you have a large csv file! And a better method would be to use two files - one is your first file, and the second is a progress-file. Say you want to change a line. Read each line in your first file and save to the second until you come to the line you want to change (which could be inserting or deleting lines/columns, cells etc). Then you can change that line and save to the second file. Read the rest of the first file until it's gone. Then close the streams. Delete the first file. Rename the second and you have it. You could also use fstream as opposed to if and ofstreams.
What you want to do is not hard but it requires more than appending data. The simplest way of managing this (I reckon), is to create a vector of a vector of strings:
std::vector< std::vector<std::string> > csv_file_contents;
don't forget to #include <vector> and <string>. First thing is to read in the current file. I reckon line by line and tokenise with comas. The manipulation becomes much easier then. You can .erase() or .insert() or push back easily enough. Then save the contents of the csv file each time.
Note - this is not a good solution if you have a large csv file! And a better method would be to use two files - one is your first file, and the second is a progress-file. Say you want to change a line. Read each line in your first file and save to the second until you come to the line you want to change (which could be inserting or deleting lines/columns, cells etc). Then you can change that line and save to the second file. Read the rest of the first file until it's gone. Then close the streams. Delete the first file. Rename the second and you have it. You could also use fstream as opposed to if and ofstreams.
|
Similar Threads
- Reading in a *.csv file and loading the data into an Array (Java)
- insert csv file into mysql through php (PHP)
- dat,txt file and csv file???? (C++)
- Need Help Reading a csv file created from MSExcel (C)
- to delete contents of a text file (Java)
- parsing csv file (PHP)
Other Threads in the C++ Forum
- Previous Thread: using namespace std problem
- Next Thread: Class Program: Help with Calculating Account Usage
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest C++ Posts
- Today's Posts
- Unanswered Threads
action api array auto based beginner binary bitmap c++ c/c++ calculator challenge char class classes code coding compile console conversion count createcopyofanyfileinc delete deploy desktop developer directshow dll download dynamic dynamiccharacterarray email encryption error file forms fstream function functions game garbage givemetehcodez graph gui hmenu homeworkhelp homeworkhelper iamthwee ifstream input insert int integer java lib linkedlist linker loop looping loops map math matrix memory multiple news node noob output parameter pointer primenumbersinrange problem program programming project python random read recursion reference rpg sockets string strings temperature template test text text-file tree url variable vector video win32 windows winsock wordfrequency wxwidgets