How to add a column of data to a .txt file?

[Blah937]

Hello everyone,

Basically, I have an ASCII file or .txt file with data like this:

Col1 Col2 Col3....
5 3
b 2
6 1
7 0

PS: Sorry, the forum won't display the correct format of the column/line arrangement I have. But they are separate columns with the data under them.

I want to write data to it in the form of a new column... for example in Col3. I already have my arrays and stuff, it's just a matter of what function/code I need that will help me to do that in an orderly way (data to respective line). I'm a novice in C++ so please help if you know useful functions and use examples please!! Thank you.

[tabstop]

You're going to have to write the whole file out again, because (attempting to) write column 3 in place will overwrite the column 1 of the next line. So read in two numbers, write out three (either right away into a temp file and move it over, or read the whole thing into memory then write the whole thing out to memory).

[Blah937]

Thanks tabstop. What function should I use? So far this is what I have...it's a loop that calculates something (in this case that something is "value"), then that something is what I am trying to add into a new column into the text file. I figured I had to do it in the loop. I'm not sure how creating a copy of the file would work because I don't think I can use my calculated values outside of my while loop.

//while loop to extract data from .txt file
  while(getline(datain, line1))
    {
	  
      istringstream datstream(line1, istringstream::in);
     
      datstream >> dum1[0] >> dum1[1] /*>> dum1[2] >>*/;
      datastore[i][0] = strtod(dum1[0].c_str(), &pEnd); //lat 
      datastore[i][1] = strtod(dum1[1].c_str(), &pEnd); //long
	 

	 
      latpix[i] = (laurentides.lat-datastore[i][0])/(laurentides.x_pixsize);
      lonpix[i] = (datastore[i][1]- laurentides.lon)/(laurentides.y_pixsize );
	
	  

      cout << "Lat : " << datastore[i][0] <<"   Lon: " << datastore[i][1] << "     " << "pixel lat: " << latpix[i] << "\t" << "pixel lon: " << lonpix[i] << endl;

      //offset here calculates the  number of pixels that the data occupies in the actual binary file and points to it 
      offset = latpix[i]*laurentides.numsamples+lonpix[i];
      
      //here were getting the size of the data in memory
      offset = offset*sizeof(float);
      cout<<"reading file at "<< offset <<endl;

      is.seekg (offset, ios::beg);

      
      is.read ((char *) &value[i], sizeof(double));
     
      cout <<"THIS IS FSEEK VALUE: " <<  value[i] << endl;
      ostringstream value_streaming;

      
      /* ----Code I was playing with to append data to my text file but not working at all ---
      value_streaming << value[i];
      string_value = value_streaming.str();
 fstream testing;
 testing.open(argv[2], fstream::in | fstream ::out|fstream::app);
      testing << string_value <<  endl;

      //string_value = value_streaming.str();
      //value[i] >> dum1[6];
      datstream >> dum1[2] >>  dum1[3] >> dum1[4] >> dum1[5] >> dum1[6];  
      testing.close();
      */

      if( i == 4)
	break;
	   
      i++;
	
    }

[tabstop]

This perhaps sounds obvious when stated this way, but when you seek to a spot in a file and then write, there aren't little gnomes inside your machine that create a little piece of disk drive just big enough to hold your extra data and then stitch it into place right where you want it; you just write on top of what was already there. In this case, "what was already there" is "the next line of what I was supposed to process". You can either read all the data in, process it, and then write the data out; or if you need/want to write as you go, you must write to a different file.

I have no idea with this code which you are trying to do (is argv[2] different from where datstream points?), so who knows. If argv[2] is a different place, and you actually bothered to write the whole thing, i.e.

testing << dum1[0] << ' ' << dum1[1] << ' ' << value << std::endl;

then you'd be fine.

[Blah937]

Ohhh I see. Thanks tabstop. I had a misunderstanding of how the whole thing was compiled. Hm..... argv[2] is basically the file I read from to do the calculations I do and the one I try to write back to.

[tabstop]

Ohhh I see. Thanks tabstop. I had a misunderstanding of how the whole thing was compiled. Hm..... argv[2] is basically the file I read from to do the calculations I do and the one I try to write back to.

If you have two streams pointing to the same file, then you can get marvelously strange things to happen. In this case, since you open testing in append mode, it can only write to the end of the file, so you aren't going to be stepping on your data. On the other hand, the data won't be where you want it.

[Blah937]

Yeah, i tried it all but the data isn't even being written to the file I want it too; I don't know what's going on.

[tabstop]

Since there's no way, short of breaking the laws of physics, to make it work that way, you might as well abandon that approach now instead of later. Either decide on (a) a new file or (b) doing it all in memory and then rewriting. If you want to make sure you are reading the data correctly out of your pixel file, you can just print the value to screen to see what you get.

[Blah937]

Yeah, I'll just create a new file and write on it; I hope it works out for me! Eeeeeeek. Thanks Tabstop.