Importdata; textheader not read completely

Question

Mark 2016-5-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/283964-importdata-textheader-not-read-completely

评论： Walter Roberson 2016-6-8

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Elias Gule 2016-5-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/283964-importdata-textheader-not-read-completely#answer_222021

在 MATLAB Online 中打开

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 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 2016-6-8

在 MATLAB Online 中打开

filename = '22P04a.csv';
fid = fopen(filename, 'rt');
headers = textscan(fid, '%[^\n]', 10);
datacell = textscan(fid, '%f');
fclose(fid);
data = datacell{1};