Re: Timestamp problems...

[PhilipNienhuis]

d.cunningham wrote
> Hello all,
> 
> I have 20 CSV files full of data, but one column is a Timestamp saved as
> text, in the format "DD/MM/YYYY HH:MM:SS" 
> when trying to import directly Octave cannot read the matrix as there is
> text, but I cannot manipulate the data correctly without importing.
> 
> when converting in other programmes, saving the text as a general or
> number data type, Octave can read the matrix but consistantly returns time
> and dates in the 1970's regardless of using epoch or unixtime etc...I
> believe this is because the numbers are being stored incorrectly after
> conversion.
> 
> I am stuck - has anyone else imported and manipulated data with a text
> timestamp like mine?

In the Octave-Forge io package there's a function csv2cell() that can read
mixed-type csv files; it returns a cell array (obviously as you can't mix
character and numeric data types in a numeric array).

So, apply datenum() on the date string column (you might need to supply a
date format like "dd/mm/yyyy HH:MM:SS", see 'help datestr') and you'll be
set.

Note: a prerequisite for cell2csv() is that all lines in your csv files
contain the same number of data.

Philip




--
View this message in context: 
http://octave.1599824.n4.nabble.com/Timestamp-problems-tp4658600p4658607.html
Sent from the Octave - General mailing list archive at Nabble.com.