How to write tabular data in .CSV file in C++?

Question

I am trying to write in a tabular form in .csv file. many string variables (freq voltage current S11 S22 S21 S12) contains big data.
for exp,

... and so on ...

first I converted all variables data row into column by replacing "," to "\n", for writing in vertical form. for exp,

convert to

string voltage , freq, curt;
freq= tmp.query("*FMA?\n");
voltage = tmp.query("*VOL?\n");
curt=   tmp.query("*CURR?\n");
replace(begin(freq), end(freq), ',', '\n');
replace(begin(voltage ), end(voltage), ',', '\n');
replace(begin(curt), end(curt), ',', '\n');
filewrite << freq<< voltage <<curt;

You have to split each line at `','` and write the values in a loop with `filewrite << freq<< ' '< — Thomas Sablik, Oct 10 '19 at 03:57
can you please explain briefly how to split line and how to get final data in tabular form? — adnan ashraf, Oct 10 '19 at 04:11
[Split string](https://stackoverflow.com/questions/14265581/parse-split-a-string-in-c-using-string-delimiter-standard-c). — Thomas Sablik, Oct 10 '19 at 05:17
i already split data by using replace(begin(freq), end(freq), ',', '\n'); , which convert horizontal data into vertical form (column into rows). but when i use filewrite << freq< — adnan ashraf, Oct 10 '19 at 06:26
You are not splitting. You need to split the each string and store each element in a container like a vector. Then you can iterate over the elements — Thomas Sablik, Oct 10 '19 at 07:12
I understand now, Thank you for your guidance. it is done by splitting as you said. — adnan ashraf, Oct 10 '19 at 08:23

score 0 · Answer 1 · answered Oct 10 '19 at 08:32

Its done. Split by "," and use token to write in tabular form.

ofstream filewrite;
filewrite.open("............");
string voltage , freq;
freq= "A1, A2, A3";
voltage = "B1, B2, B3";

string delimiter = ",";
    size_t pos = 0;
    string token, token2;
    while ((pos = freq.find(delimiter)) != string::npos && (pos =voltage .find(delimiter)) != string::npos)
    {
        token = freq.substr(0, pos);
        token2 = voltage .substr(0, pos);
        filewrite << token << "," << token2 << endl;
        freq.erase(0, pos + delimiter.length());
        str2.erase(0, pos + delimiter.length());
    }

    filewrite << freq<<"," << voltage ;
filewrite.close();

}

How to write tabular data in .CSV file in C++?

1 Answers1