find a word in a sentence in a cell

2 次查看（过去 30 天）
Amr Hashem
Amr Hashem 2015-5-10
评论： Stephen23 2015-5-18
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.

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

采纳的回答

Star Strider
Star Strider 2015-5-10
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.
  2 个评论
Amr Hashem
Amr Hashem 2015-5-15
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
Amr Hashem 2015-5-18
how i can use "strfind" instead of " strcmpi" and return 1 or 0

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by