comparing table values using isequal

Hi,

I have a table M. The second column contains either the letter 's' or letter 'f'.

I would like to put all the rows with the letter 'f' in the second column into a new table A with the following code

pocet_radku = height(M);
j=1;

for i=1:pocet_radku
    TF = isequal ("M(i,2)",'f')
    if TF == 1
        
       A(j,:)= M(i,:);
       j = j+1;
    else
    end
    
end

Unfortunatelly, the isequal function return only zeros. Any idea why? In there syntax error that I'm not aware of?

Testing in a command window:

>> isequal ("M(180,2)",'f')

ans =

  logical

   0

>> M(180,2)

ans =

  table

    Var2 
    _____

    {'f'}

Thanks a lot for any answers

Answer 1

[Cris LaPierre]

This can be done much simpler. Try something like this.

A = M(M{:,2}=="f",:);

[Jakub Steiner]

Nice! Works as well and without my clumsy cycles.

Thanks a lot!

[Cris LaPierre]

This can be made even simpler by using the variable name:

A = M(M.Var2=="f",:);

Answer 2

[Fangjun Jiang]

try TF = isequal (M.Var2{i},'f')

[Jakub Steiner]

Works! Thank you a lot

Answer 3

[BOB MATHEW SYJI]

Instead of

TF = isequal ("M(i,2)",'f')

try,

TF = strcmp (M.2nd_variable,'f')