Reading large file in matlab with unique data format -

i dealing loading data 250 mb csv file matlab. data looks following:

col1    col2           col3     col4        col5     1       5/1/2014       1       18.4765      18.1938  

when like:

y = csvread('datafile.csv'); 

the second column date , hence when use csvread, variable y appears following:

1   2014    -5  -1  1   18.4765000000000    18.1938000000000 0   0        0   0  0   0                   0 

so, problems dealing are:

(1) dates messed (2) row zeros gets added

how read such data file ?

from csvread documentation: read comma-separated value file

your csv file contains contents besides values.

if have microsoft excel can try using xlsread: http://www.mathworks.com/help/matlab/ref/xlsread.html

[num,txt,raw] = xlsread('myfile.xls'); 

otherwise have done manually, can try function answer:

import csv file mixed data types