How to select certain data from .txt file

3 views (last 30 days)
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.

Accepted Answer

Guillaume
Guillaume on 22 Mar 2018
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

More Answers (0)

Categories

Find more on Cell Arrays in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!