How to get particular data from column of table in MATLAB-CodePudding

i have this type of table. which is in the below image.

now I need only the row where this "LBNP:30" type of data is available in last column. please help. I am new to MATLAB.

i need this type of output. please help.

CodePudding user response：

I've prepared a similar xlsx-file and next read it with readtable function

T = readtable('test.xlsx','ReadVariableNames',false)

Then you can make logical array with detecting rows you need:

idx = ismember(T.Var5,'LBNP:30')

And next just select these rows:

T(idx,:)

CodePudding user response：

T = readtable('data.csv')

this line gives the below output.

then write this below code.

X = cellfun(@isempty,T.Var5);
T(X,:)= []