Compare multiple columns in a cell array with strcmp

10 次查看（过去 30 天）
Dave
Dave 2016-2-2
编辑： Stephen23 2016-2-2
I have an m x n cell array. I would like to pull specific rows that match strings from different columns. Currently, I'm accomplishing this with two matlab lines as follows:
hill_log = runlog1(strcmp(runlog1(:,4), 'Hill'),:);
hill_log2 = hill_log(strcmp(hill_log(:,6), 'Kilometer'),:):
I'd like to be able to do this on one line with one strcmp, possible?
Thanks Dave
  3 个评论
显示 1更早的评论
Guillaume
Guillaume 2016-2-2
What will make the code 100% clearer is a comment that states the intent.
Otherwise, I do believe that a one-liner using logical operations express the intent better that you want all runlog1 where column 4 is Hill AND column 6 is Kilometer.
Stephen23
Stephen23 2016-2-2
编辑：Stephen23 2016-2-2
It is all a matter of taste of course, I would do something like this:
ishi = strcmp(runlog1(:,4), 'Hill');
iskm = strcmp(runlog1(:,6), 'Kilometer'):
hill_log2 = runlog1(ishi & iskm, :);

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2016-2-2
Hum, why not use logical operations?
hill_log2 = runlog1(strcmp(runlog1(:,4), 'Hill') & strcmp(hill_log(:,6), 'Kilometer'), :);
In my opinion, it expresses the intent better than concatenating strings with a special character.

更多回答（1 个）

Walter Roberson
Walter Roberson 2016-2-2
hill_log2 = runlog1( ismember( strcat(runlog1(:,4), char(65535), runlog1(:,6)), ['Hill' char(65535) 'Kilometer']), :);
You could use strcmp() instead of ismember() if you prefer.
char(65535) can be any character that you are sure does not appear in the columns. Except maybe char(0), that one is touchy, some of the routines malfunction on char(0)

类别

在 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