Return rows (not just row number)
6 views (last 30 days)
Show older comments
Hello
I would be happy if anyone could help me with following problem.
I have an text (or excel) file which is in the following form (or course in reality it is in larger form but anyway the basic idea is):

And now I would like to find all the 'Cat'-rows and return that row and the following row.
So in the end my answer should be

And I don't even know how to begin. Could anyone help?
0 Comments
Accepted Answer
Ingrid
on 29 Jan 2016
just use strfind or strcmp to find the indices
varNames = var(:,1);
IndexC = strfind(varNames, 'Cat');
Index = find(not(cellfun('isempty', IndexC)));
Index = sort([Index; Index+1]);
extracted = var(Index,:);
0 Comments
More Answers (3)
Walter Roberson
on 29 Jan 2016
match = ismember(var(:,1), 'Cat');
extended_match = match | [true; match(1:end-1)]; %row and following row; and also header
extracted = var(extended_match, :);
0 Comments
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!