Import .csv that has the characters '-'

6 次查看（过去 30 天）
Raldi
Raldi 2014-3-23
编辑： per isakson 2014-3-23
I have an .csv file as you can see below and was wondering how to import it into matlab. 'csvread' wont work from what I've tried. Thanks for any help you might offer.
Date,Open,High,Low,Close,Volume
23-Mar-10,40.90,41.50,40.74,41.30,44335408
22-Mar-10,38.90,41.03,38.80,40.40,50007926
19-Mar-10,40.30,40.50,39.00,39.00,55803035
18-Mar-10,40.90,40.90,40.00,40.20,35021589
17-Mar-10,41.00,41.70,39.90,40.50,68063581
16-Mar-10,39.50,40.68,39.20,40.50,54320539
15-Mar-10,38.80,39.40,38.30,38.90,63595754

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

采纳的回答

per isakson
per isakson 2014-3-23
编辑：per isakson 2014-3-23
Not tested:
fid = fopen( 'filename.csv' );
cac = textscan( fid, '%s%f%f%f%f%f', 'delimiter', ',', 'headerlines', 1 )
fclose(fid);
and
sdn = datenum( cac{1}, 'dd-mmm-yy' );
.
See: Text Files, Delimited or formatted I/O to text files

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by