read from CSV file-complex

1 visualización (últimos 30 días)

ron el 16 de En. de 2013

hi, i have aCSV file looks like this:

2012-02-09 00:00:36,11002,86,1,0,376,0,0,0,0,0

2012-02-09 00:00:39,11002,86,1,0,622,0,0,0,0,3

the fields are: datetime|int|int|int|int|int|int|int|int|int|int|

i want to read it into a matrix that will look like this:

year|month|day|hour|all other numeric columns. any suggestions?

P.S the data amount in large, about 3 millon rows...

Ilham Hardy el 16 de En. de 2013

Download this function from File Exchange:

And look in the comment, specifically for example no.4 in the m-file.

HTH,

Ilham

MATLAB Language Fundamentals Data Types Characters and Strings String Parsing

Más información sobre String Parsing en Help Center y File Exchange.

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by