find a word in a sentence in a cell

i want to search for all the rows (:,6)that contain a specific word

i try :

[num text alldata] = xlsread('result.xlsx','1'); % import excel file

j=1;

k=1;

for i=1:size(alldata,1)

d = regexp(alldata{i,6},'[ ]*','split') % this split sentences but didn't save

for L=1:length(d)

idx(k)=l;

k=k+1; end

if isequal (alldata{i,6},'battery') % search for word "battery"

defs(j)=i;

j=j+1;

end end

data=alldata(defs,:);

but it didn't work....!

SOS...any help please.

[Stephen23]

The question is continued here:

http://www.mathworks.com/matlabcentral/answers/217324-find-a-word-in-sentence-by-strfind

Answer 1

[Star Strider]

I don’t have your data so I can’t run your code or test this, but see if:

if strcmpi(alldata{i,6},'battery') % search for word "battery"

improves your code.

It uses the strcmpi (case-insensitive string comparison) to do the test.

[Amr Hashem]

please could you help me in ... i have this two tables querymdr & idx2 :

i want to compare the fisrt two coulmns of them , and the multiple value copy column 6 of it only

i want to have the answer like this:

what i can do? any one has an idea?

[Amr Hashem]

how i can use "strfind" instead of " strcmpi" and return 1 or 0