MATLAB: Return rows (not just row number)

return row

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?

Best Answer

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,:);

Related Solutions

MATLAB: Find a word in sentence by “strfind”

You can simply wrap the strfind inside isempty, like this:

>> ~isempty(strfind('Schroedingers cat is alive!','cat'))
ans =
   1

You can also use regexp to quickly identify matching substrings. Here is a simple example that locates the string cat inside a cell array of strings.

>> A = {'the cat sat on the mat','the cat in the hat','four blind mice','cats!'};
>> ~cellfun('isempty',regexp(A,'cat'))
ans =
     1     1     0     1

And if you want case-insensitive matching then use regexpi instead. Note that regexp also has many other powerful features that may be of interest to you... the documentation explains these, with examples too.

MATLAB: Search folders/paths with strfind: how to do excluding search

You could just leave out the call to NOT in Index3.

Best Answer

Related Solutions

MATLAB: Find a word in sentence by “strfind”

MATLAB: Search folders/paths with strfind: how to do excluding search

Related Question