Printing specific rows based on column from excel

Good Day,

I have an excel sheet with 7296 rows and 9 columns. So, I want to get certain rows only based on the column value. For example:

Time Node FaceID FaceDescr Type Packets Kilobytes PacketsRaw KiloBytesRaw

Like the above snippet I have certain rows with the FaceDesc 'ALL' as one of the columns. So, I want my code to print only those rows. I have some unecessary rows that I don't want the code to print like the below screenshot shows. Can anyone please nudge towards the right direction of getting what I need? I'm new to MatLab. Thank you.

Answer 1

[KSSV]

T = readtable(myfile) ;
idx = matches(T.FaceDescr,'all') ;
T(idx,:)

[Sai Gautam Mandapati]

Thank you so much! Works perfectly.

[Sai Gautam Mandapati]

@KSSV For suppose, If I want my code to print all the rows under FaceDescr:'appFace:// ' and Type: 'InInterests'. How can I do that?

[KSSV]

Get indices of each column and use logical and.

[Sai Gautam Mandapati]

Thank you!