Opening a CSV File [modified]

ndeza

Hi All, I've got an application that opens a csv file and save the data in the file to a Database. When the app reads the file it only reads the second column my problem is, the format of the date in the file has changed the date use to be like, 20081019 now it has changed to "October 26, 2008",. The file is like Day,Visitors "October 26, 2008",356 where day is the date. Now the app reads year 2008 when i want it to read the Visitors 356. Please can you help me:):) Regards, Ndeza

modified on Tuesday, October 28, 2008 4:52 AM

Rajesh R Subramanian · modified on Tuesday, October 28, 2008 4:52 AM

Who has the time to go through all that rubbish? Please post only "relevant" code, if required. Read the guidelines before posting a question.

It is a crappy thing, but it's life -^ Carlo Pallini

ndeza

How about now

Vikram A Punathambekar · modified on Tuesday, October 28, 2008 4:52 AM

Not sure I understand... but you're saying the CSV actually has the enclosing quotes? Then it is the app which fails to parse properly. There are libraries that handle CSV files, you're better off using one of them.

Cheers, Vıkram.

"You idiot British surprise me that your generators which grew up after Mid 50s had no brain at all." - Adnan Siddiqi.