MATLAB: How to filter required data

data acquisitionData Acquisition ToolboxdatabaseStatistics and Machine Learning Toolbox

Hi,
I have below table. I want to take the data under "actual measurement" till stop, but in between there should not exist except complete or paused or stop. for example I want the below cases:
    actual measurement           start              2016/4/5           
    complete                     BA0K2              23
    complete                     BY0P2              3
    stop                         HYT0KL             54
AND
actual measurement           start              2016/4/7           
paused                       VA0L2              89
paused                       BY0P2              3
stop                         HYT0KL             54
But I dont want:
measurement restart          start              2016/4/7           
complete                     VA0L2              89
paused                       BY0P2              3
stop                         HYT0KL             54
AND
actual measurement           start              2016/4/7 
actual measurement restart   start              2016/4/7                     
paused                       VA0L2              89
stop                         HYT0KL             54
My Table:
actual measurement           start              2016/4/5           
complete                     BA0K2              23
complete                     BY0P2              3
stop                         HYT0KL             54
measurement restart          start              2016/4/7           
complete                     VA0L2              89
paused                       BY0P2              3
stop                         HYT0KL             54
actual measurement           start              2016/4/7           
paused                       VA0L2              89
paused                       BY0P2              3
stop                         HYT0KL             54
actual measurement restart   start              2016/4/7           
paused                       VA0L2              89
stop                         HYT0KL             54
actual measurement           start              2016/4/7 
actual measurement restart   start              2016/4/7                     
paused                       VA0L2              89
stop                         HYT0KL             54

Best Answer

In order for you to run this code you must convert your data (aka the table) into cell using the cell2table() and store it into variable named 'data'
result = {};
startRows = find(strcmp(data(:,1),'actual measurement'));
stopRows = find(strcmp(data(:,1),'stop'));
nloop = length(startRows);
for i = 1:nloop
      sectionStop = find(startRows(i)<stopRows,1,'first');
      if strcmp(data(startRows(i)+1:stopRows(sectionStop)-1,1),'complete') | strcmp(data(startRows(i)+1:stopRows(sectionStop)-1,1),'paused')
          result = [result; data(startRows:stopRows(sectionStop),:)];
      end
  end
Related Question