Printing specific rows based on column from excel

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

Accepted Answer

KSSV
KSSV on 11 Apr 2022
T = readtable(myfile) ;
idx = matches(T.FaceDescr,'all') ;
T(idx,:)
  4 Comments
KSSV
KSSV on 12 Apr 2022
Get indices of each column and use logical and.

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!