remove rows with certain element in cell arrays

In the following data set, I want to keep only the rows with 'Hourly' element, thus only row 2. I use the following, but it doesn't work. Can anybody help me?

data={'s' 'e' 'daily'; 't' 'c' 'hourly'; 'm' 'b' 'daily'}

 data_2 = cellfun(@(x) x(x(:,3)=='Hourly'), data, 'UniformOutput', false)

Answer 1

[Geoff]

Did you mean to write:

x{:,3}=='Hourly'

The curly-braces thing trips me up all the time =)

[Geoff]

Err... Sorry, this works:

data_2 = data(find(strcmp(data(:,3), 'hourly')),:)

-g-

[FATEMEH]

thanks a lot!

Answer 2

[Jan]

data = {'s' 'e' 'daily'; ...
        't' 'c' 'hourly'; ...
        'm' 'b' 'daily'};
data2 = data(strcmpi(data(:, 3), 'hourly'), :);

[FATEMEH]

thanks a lot!