MATLAB: Compare multiple columns in a cell array with strcmp

strcmp

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

Best Answer

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.

Related Solutions

MATLAB: Problem with find function

You can use strcmp to obtain the logical index (which often faster and more convenient to use than subscript indices):

>> hbs_ort = {'North' 'North' 'South' 'South' 'East' 'West' 'West' 'East'};
>> cabs_ort = {'North'};
>> X = strcmp(hbs_ort,cabs_ort) % logical index
X =
   1   1   0   0   0   0   0   0

If you really need to subscripts:

>> find(X)
ans =
   1   2

EDIT: if cabs_ort contains multiple values, then use ismember instead:

>> hbs_ort = {'North' 'North' 'South' 'South' 'East' 'West' 'West' 'East'};
>> cabs_ort = {'North','South'};
>> X = ismember(hbs_ort,cabs_ort)
X =
   1   1   1   1   0   0   0   0

MATLAB: How to extract a row of data from a cell array based on a string

cat(1,runlog1{:,4})

This is a cell so you can't compare it to a string. Instead use strcmp which works on cells and strings in this manner. Something like:

strcmp(cat(1,runlog1{:,4}),'Hill')

Best Answer

Related Solutions

MATLAB: Problem with find function

MATLAB: How to extract a row of data from a cell array based on a string

Related Question