Access Table rows if variable value == ... Problems with string variables.

Question

roblocks 2016-6-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/292929-access-table-rows-if-variable-value-problems-with-string-variables

评论： roblocks 2016-6-29

Dear All, suppose you have a table. I want to access certain rows based on variables values, for example if datecode == 20001231 & country_code == 'ES'. The following code works for numerical variables, but not for strings:

test = EBADATA_DEFINITIONS(EBADATA_DEFINITIONS.MATURITY_CODE  == 999     ...
                       & EBADATA_DEFINITIONS.INFORMATION_CODE == 34010 ...
                       & strcmp(EBADATA_DEFINITIONS.C_COUNTRY_CODE,'ES'),:);

I have tried to manipulate the country column in various ways before running the command above , but I always end up with one or another error.

EBADATA_DEFINITIONS.C_COUNTRY_CODE = char(EBADATA_DEFINITIONS.C_COUNTRY_CODE)
EBADATA_DEFINITIONS.C_COUNTRY_CODE = cell2str(EBADATA_DEFINITIONS.C_COUNTRY_CODE)

Could someone point me towards the correct way of doing this?

I appreciate your help!

Best!

[This has been cross-posted @ http://www.gomatlab.de/viewtopic,p,166432.html#166432]

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-6-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/292929-access-table-rows-if-variable-value-problems-with-string-variables#answer_227115

在 MATLAB Online 中打开

It seems to work for me:

t = cell2table({15, 134, 'hello'; 82, 419, 'there'; 15, -999, 'hello'}, 'VariableNames', {'MATURITY_CODE', 'INFORMATION_CODE', 'C_COUNTRY_CODE'});
t(t.MATURITY_CODE == 15 & strcmp(t.C_COUNTRY_CODE, 'hello'),:)