MATLAB: Find a word in a sentence in a cell

data miningfind wordsearch in a cell in excel sheet

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.

Best Answer

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.

Related Solutions

MATLAB: How to search in a text cell by a word

The standard comparison functions used with numeric variables don’t work with strings. Consider using strcmp or its many friends (most of them linked to on that page). One of them should work for you.

MATLAB: Find a word in sentence by “strfind”

You can simply wrap the strfind inside isempty, like this:

>> ~isempty(strfind('Schroedingers cat is alive!','cat'))
ans =
   1

You can also use regexp to quickly identify matching substrings. Here is a simple example that locates the string cat inside a cell array of strings.

>> A = {'the cat sat on the mat','the cat in the hat','four blind mice','cats!'};
>> ~cellfun('isempty',regexp(A,'cat'))
ans =
     1     1     0     1

And if you want case-insensitive matching then use regexpi instead. Note that regexp also has many other powerful features that may be of interest to you... the documentation explains these, with examples too.

Best Answer

Related Solutions

MATLAB: How to search in a text cell by a word

MATLAB: Find a word in sentence by “strfind”

Related Question