help-octave
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

fgetl and time in csv file


From: Nicholas Oleng
Subject: fgetl and time in csv file
Date: Thu, 10 Jul 2008 13:12:10 -0700 (PDT)

I've got a csv file I'd like to read into Octave.
 
The typical line is as follows:
9/16/2007  5:26:49 PM,1.000675626, 692981.8033,USD->DKK->EUR

Unfortunately, when I use fgetl I get the following:
9/16/2007  5:26,1.000675626, 692981.8033,USD->DKK->EUR
where the :49 PM is omitted for some reason. Note this is how it appears when opened in Excel, although one can actually view the seconds and PM by clicking on the individual cell.

How can I remedy this so that Octave can also read the second and the PM?

########
1.000676
692981.8
USD->DKK->EUR
########
1.000676
692981.8
USD->DKK->EUR
1.000676
692981.8
USD->DKK->EUR
1.000676
692981.8
USD->DKK->EUR
1.000676
692981.8
USD->DKK->EUR


reply via email to

[Prev in Thread] Current Thread [Next in Thread]