MATLAB: Reading data from csv or tsv file starting from some line

MATLABread

Hi All,

I need to read data from a file openable in notepad. The file format can be csv or tsv. But the data will start from some line say 3 or 4.

Similar file has been attached. In this file the values are starting from line 5 and format is tsv. So line 5 will be read first and there will be five values which should be stored in a matrix and then line 6 values and so on.

I have tried too many ways but nothing is working.

Thanks all

Best Answer

Is the format of your data the same in all your files? If yes, then use the import tool. This will allow you to interactively configure your import. You can then generate the corresponding code (as a script or a function) that can be used to automate the import process of all files with the same formatting.

If you do want to create an importing function, this video shows you how to generate and reuse your code.

And if you have a lot of files, this video shows you how to use the import function you have created in conjunction with a datastore to import multiple files.

I'd suggest reading your data in as a table. This short video shows how to access data in a table.

Related Solutions

MATLAB: Import txt file containing some comment character = “#”

Mention:

    ....'CommentStyle','#')
fileID = fopen(filename);   %an example 
C = textscan(fileID,formatspec','Delimiter',',','CommentStyle','#');
fclose(fileID);

MATLAB: Importdata misses some of the data in the file

This is not enough information to suggest an improvement. Please post the code and the attach the file, or better find out the part of the file, whcih cannot be imported successfully. Perhaps there are some unexpected characters, commas instead of decimal points or such details.

While importdata is really smart, the file format looks easy. Perhaps a dumb approach would be sufficient already:

function [Header, Data] = YourImport(FileName)
fid = fopen(FileName, 'r');
if fid == -1
  error('Cannot open file: %s', FileName);
end 
Header = cell(1, 3);
for k = 1:3
  Header{k} = fgetl(fid);
end
Data = fscanf(fid, '%g %g', [2, inf]).';  % Or however your "cloumns" are separated
fclose(fid);
end

Perhaps this helps already.

Best Answer

Related Solutions

MATLAB: Import txt file containing some comment character = “#”

MATLAB: Importdata misses some of the data in the file

Related Question