Thread: date

Sorry if my questions seem pointless, the reason I am asking them is to try and understand the code better and see if something could be causing a problem. The reason I thought the SIZE was the problem, was because I thought you wanted it to output the other columns.

Now I know that you only want to output 1 column it makes sense.

Is there 1447 lines in this file?

For a start you could try to make clear what you really want. You say you want to find out a date from the first column of a csv-file. At the same time you declare your function that is supposed to return the date with a return-type of float. So how do you want to encode a date in a float ?. Your code looks like you are reading a lot of lines from the file but at the same time you say all lines contain the same date. You say you want to post a sample csv-file but you post an xls-file. ( i cannot read that. this is not a windows-box ). If the forum doesn't let you post the csv you could just rename it. If its too big, post a part of it.
You are making it hard to help you.
Kurt

This way you can get the value of any column in the file as string.
If you need the date in some other format you have to convert it.

Code:

#include <iostream>
#include <sstream>
#include <fstream>
#include <string>

using namespace std;

// string GetdateValue(int column,string line) {
string GetColumnValue(int column,string line) {  // use meaningful names
     string temp;
     stringstream sstr(line);
     for( int i = 0; i < column; ++i )
        getline(sstr,temp,',');  // read into temp separated by ','
     return temp;                // return last read value
}
 
int main() {
    ifstream input_file("Log_05.txt");// is a scv file have many coulmn first column of it is the date
    string line;
    int count;
    string date_str;   // they are all the same
    string time_str;   // for demonstration
     
    if ( input_file.fail ()) { 
         cout << "Error opening file.";
     }
     else  {
         count = 0;
         while( getline(input_file,line) && count <= 1447) {  // while there is no error and linecount < 1448 if you want it like this
            if ( count == 20 ) {         // get date from line 20 
               date_str = GetColumnValue( 1, line ); // date is col 1
               time_str = GetColumnValue( 2, line ); // time is col 2
            }
            count++;        // Increment the count, to go to the next line
         }
         cout << "date is '"<< date_str << "' time is '" << time_str << "'" << endl;        
    }
    return 0;
}

I really don't believe this.

I thought the .xls file he uploaded was the csv file but just renamed because the forum didn't accept that attachment type. It is the reason I asked him to post the file so I could see the format of it.

It wasn't even the correct file I had, I just renamed it to .csv, no wonder I wasn't getting anywhere.

thank you all for all the effort, I would not be able to do it without your help.