清空筛选条件
清空筛选条件

read from CSV file-complex

2 次查看（过去 30 天）
ron
ron 2013-1-16
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...

请先登录，再回答此问题。

回答（1 个）

Ilham Hardy
Ilham Hardy 2013-1-16
Download this function from File Exchange:
http://www.mathworks.ch/matlabcentral/fileexchange/18430-txt2mat
And look in the comment, specifically for example no.4 in the m-file.
HTH,
Ilham

类别

在 Help Center 和 File Exchange 中查找有关 String Parsing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by