Importdata; textheader not read completely

2016 5 12
1 个回答
更新时间：2016 6 8
4 次查看（30 天）

0 个投票

I have a lot of data files like the ones attached. These were all read using the following line:
data = importdata(fullfile(pcsv,fcsvTemp));
This worked fine, until just recently when some of the files were not loaded correctly. I.e. the textheader at the start f the file is not read completely, and numeric data is not read at all (only 2x2 matrix instead of very long matrix) I really don't see any difference between the files in the header, can anyone help?

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

回答（1 个）

Elias Gule
Elias Gule 2016-5-13

0 个投票

Try reading the file data into a string and use the textscan function to retrieve the data you want.
filename = '22P04a.csv';
filetext = fileread(filename);
data = textscan(filetext,'%f','HeaderLines',10); % returns a cell array of cells
data = cell2mat(data) % get the data as matrix

2 个评论
显示 无 隐藏 无

Mark
Mark 2016-6-8
Hi, First of all, thanks, it works well for the numeric data. However, the first lines are also important to me (retrieving subjectcodes, date etc.), and I would like to get these as a cell matrix (per line a cell). Using strsplit I can get each word, but not each line within a cell. Since header can vary slightly, it is quite important that i can read each line into a cell. Suggestions?
Walter Roberson
Walter Roberson 2016-6-8
filename = '22P04a.csv';
fid = fopen(filename, 'rt');
headers = textscan(fid, '%[^\n]', 10);
datacell = textscan(fid, '%f');
fclose(fid);
data = datacell{1};

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by