Extract specific info out of file

Hi,

I have a file (txt file) with info, for example kids and their scores. String (name), Int (scores), String (passed/notpassed).

For example,

Jessica 8 passed

Tom 6 passed

Ronald 4 notpassed

My question now is how can I extract the ones who passed the test and with that their scores in a new Array/File/other?

Thanks in advance

Answer 1

[dpb]

txt=readlines('yourfile.txt');
writematrix('yournewfile.txt',txt(~contains(txt,'notpassed')),'filetype','text','quotestrings',0);

[Corneel Lootens]

hero, big thanks!