-
Hi John_
I do not have any problem with these previous links, I fixed all the problem with these in the past. They are working perfectly and gives the right result and I check the out put even manually, and I submitted that part.
the new requirement for the same file is to get the date from the fistr column just once because,if you check the L_05.csv you will find that all the date column are the same for aspecific date.
When you said you only getting 0 it is making me :confused: because In my runnin or debugging I am getting 10 the dd of the date column.
the L_05.csv I post is part from I big on, because it did not let me post the whole csv or even zip as it has a big file size. may be thats why you may be getting 0 result. I would like to post you the whole L_05.csv but I am not sure how.
thank you
-
any idea
if I am getting only the dd from the dd/mm/yyyy so I think my format is not right for the function.
any ideas :confused: I am absolutly stack with this function
I do not think SIZE is the problem becuase even if you change the code to SIZE=9 is giving wrong result only 0s.
If I know how to solve it I would but I am not, that why I came to you guys, any suggestion with it.
-
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
-
Hi John_
yes 1447 row and 196 column, in my original csv file I left the first 6 row as they not rquire. from 7 row where you will find the heading of each column, starting from row 8 you will find the 10/10/2004.
in that file the date of the first column will repeated in all the 1447 rows, so getting one value of the date would be more than enough.
I really sorry for keep asking, as I feel Iam lost and thank you for all you effort to solve my problem, I am gratefull.
can anyone suggest a new function or a way to get that date only once.
-
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.