MATLAB Answers

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

2 views (last 30 days)
STEPHEN BARRETT
STEPHEN BARRETT on 4 Oct 2018
Answered: Harsh on 4 Oct 2018
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'."

  0 Comments

Sign in to comment.

Answers (1)

Harsh
Harsh on 4 Oct 2018
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)), :);

  0 Comments

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by