MATLAB: How to select certain data from .txt file

arraymatrix arraytext file

I have text file with three columns and a lot of rows. The third column has a value of either 1 or 0. I want to choose the rows for which the third column is 0 and write it in a new text file.

Best Answer

Probably the easiest, assuming your text file format is straightforward to decode:

filecontent = readtable('c:\somewhere\somefile.txt');  %readtable should be able to figure out the format on its own
filteredcontent = filecontent(filecontent{:, 3} == 0, :);  %keep content where 3rd column is 0
writetable(filteredcontent, 'c:\somewhere\newfilename.txt');  %and save

Related Solutions

MATLAB: How to open multiple .txt files

If all the files have the same structure/data format, you can use datastore to merge them:

fileNames = {'t1.txt', 't2.txt', 't3.txt'}
ds = readall(datastore(fileNames)); % change other properties if needed

otherwise, you can use readtable within a loop

fileContents = {};
fileNames = {'t1.txt', 't2.txt'};
for i = 1:numel(fileNames)
    fileContents{i, 1} = readtable(fileNames{i});
end

MATLAB: Import columns from a CSV by header name

The csvread function is capable of doing what you want to do.

Best Answer

Related Solutions

MATLAB: How to open multiple .txt files

MATLAB: Import columns from a CSV by header name

Related Question