Importdata; textheader not read completely

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?

Answer 1

[Elias Gule]

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

[Mark]

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]

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