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

1 次查看（过去 30 天）
STEPHEN BARRETT
STEPHEN BARRETT 2018-10-4
回答： Harsh 2018-10-4
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'."

请先登录，再回答此问题。

回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by