Thread: Navigating Columns and Rows of a CSV file

Hi,

The Problem: Navigating through a CSV file to write data in specific columns and rows.

This is the logic behind the code I am planning:
- Create the CSV file.
- Enter loop which will run the core function numerous times produces numerous sets of data to be saved to the csv file.
- Close and clear.

The problem I foresee is this...
Each run of the core function will produce 2 columns of data. Each time I run the core function I would like to append further columns to the csv file. e.g.) After run 1 columns A and B are filled with data, after run 2 - further data is added to columns C and D, etc.

My question is this, how can I write, for example, to the 1st row of the 3rd column after my initial data write??? To put it another way, after the first set of data has been written to columns A and B, how do I code for then writing to the next available column space for the next set of data?

Thanks for reading. Any suggestions will be gratefully received.

Or, if you want to make sure you have a CSV file after every run (not clear to me whether this is what you want or not), then you write the original CSV file the first time your core function runs, then every time after that you open the previous CSV, read a line, add to it, and write it out (somewhere else).

Thanks for your suggestions.

I will look further in to seekp/seekg.

I only want 1 CSV file. Ideally, it will be created and at the start of the program, be added to as the function is called and then it will be closed before the program ends.

The thing is, on each core function call there will be an additional data set produced which I want to add to the CSV file. Each data set comprises of 2 columns of data (the number of rows may vary between data sets).
Please see attached JPEG for clearer understanding of what I am hoping to do.
Basically, I am wanting to append new columns of data each run.


Thanks again

Alright, it says C++ at the top of the page: Why not build a vector of vectors, and then at the very end write it out to a file? If you have rows where you only have elements in columns 5, 6, 9, and 10, you'll have some work to do, but otherwise it looks like what you want.