how can I select rows data from imported file

I have the following data from text file( Large data). I imported the file to matlab,

Small sample example of the data:

CATE VarName2 VarName3 VarName4 SATE

MODEL 2019 56 0 GPS

MODEL 2019 56 0 GPS

MODEL 2019 56 0 GPS

MEAS 2019 56 7650 GLO

M EAS 2019 56 7650 GPS

MEAS 2019 56 7650 GPS

MODEL 2019 56 0 GPS

MODEL 2019 56 0 GPS

MEAS 2019 56 7650 GPS

for example: from column (CATE) I want to choose the rows of MODEL only with out MEAS?

Also from column (SATE), if I want to choose all rows who has GPS only How I can do it?

The number of columns of 'MODEL row' are more than the number of columns in 'MEAS'.

Answer 1

[KSSV]

T = readtable(myfile) ; 
idx = contains(T.CATE,'MODEL') ;  % also have a look on strcmp
T(idx,:)

[Eman Saleem]

Thank you , I have now the following error ( I use your code)

Warning: Table variable names were modified to make them valid MATLAB identifiers. The original names are saved in the VariableDescriptions property.

[KSSV]

Attach your data. This can be resolved using options in readtable.

[Sura Raya]

i have same error, since we use (.out) not text or excel and columns dont have id ( CATE VarName2 VarName3 VarName4 SATE ) unless we import it in matlab, and readtable doesn't accept this type of files.