find a word in a sentence in a cell
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Amr Hashem
il 10 Mag 2015
Commentato: Stephen23
il 18 Mag 2015
i want to search for all the rows (:,6)that contain a specific word
i try :
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/149991/image.jpeg)
[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.
Risposta accettata
Star Strider
il 10 Mag 2015
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.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Characters and Strings in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!