MATLAB: How to ignore or delete the last row of a text file when importing

MATLABtextscan last row bad data ignore

I am reading in data using textscan. Often times the last row of data is bad and throws an error. How can I ignore the last line? or is there code to delete the last row of data in the text file programmatically?

Best Answer

It’s difficult to be specific without your file. If you know how many lines you want to read, you can set that limit as a parameter.

From the documentation:

C = textscan(fileID,formatSpec,N) reads file data using the formatSpec N times, where N is a positive integer. To read additional data from the file after N cycles, call textscan again using the original fileID. If you resume a text scan of a file by calling textscan with the same file identifier (fileID), then textscan automatically resumes reading at the point where it terminated the last read.

Related Solutions

MATLAB: I want to delete all the headerlines and delimiters from the data in the below attached text file

The best solution is probably to read your entire file as text, then remove the header lines, then parse them with textscan.

MATLAB: Load a txt file:

You could use the function textscan, which lets you select the headerlines to ignore (so you don't need to delete any lines by hand), and also define the number of rows that should be read into MATLAB.

EDIT to match newly uploaded textfile.

This code reads that text file, including the header, the matrix, and the trailing data. It also adjusts automatically to the number of columns.

fid = fopen('myexamplefile.txt','rt');
line1 = fgetl(fid);
hdr = regexp(fgetl(fid),'\S+','match');
fmt = repmat('%f',1,numel(hdr));
C = textscan(fid,fmt);
D = textscan(fid,'%s%s%s%s',1,'HeaderLines',1);
fgetl(fid);
E = textscan(fid,'%s%f%f%f%f',1,'HeaderLines',1);
fclose(fid);

Best Answer

Related Solutions

MATLAB: I want to delete all the headerlines and delimiters from the data in the below attached text file

MATLAB: Load a txt file:

Related Question