How to do i pull certain entries out of a table when another cell column meets a certain condition?

It's a long question but what I want to do is very simple.

Say i have a table that was imported.

T=5×6 table

    A         B    
    _     _________    
    1     'string 1'
    2     'string 2'   
    3        '5' 
    4        '6'

When i import this table it converts the 5 and 6 to strings in cells. I just want to return everything in A that doesn't have a 'string*' in column b. 3; and 4 in this case.

Problem for me is that this does not work:

T.A(T.B ~= 'string*')

i get: "Undefined operator '~=' for input arguments of type 'table'."

Answer 1

[Harsh]

As an example you can try this:

>> T = table([1:4]', {'string 1'; 'string 2'; '5'; '6'}, 'VariableNames', {'A', 'B'} );
>> res = T.A(~(strncmp(T.B, 'string', 6)), :);