Reading cells extension wise in matlab.

how to read the excel cells according to extension wise and how to count them? Foe an example, if I have this column

q.txt
w.txt
e.txt
r.exe
t.exe
and I want to count the number of txt file names as well as number of exe file names in the sheet. How to do so?

Answer 1

[Azzi Abdelmalek]

A={'q.txt';'w.txt';'e.txt';'r.exe';'t.exe';'k.xls';'m.xls'}
% xls files
out_xls=A(cellfun(@(x) ~isempty(strfind(x,'.xls')),A))
% Number of txt file
nuber_txt=sum(cellfun(@(x) ~isempty(strfind(x,'.txt')),A))

[Anurag Pujari]

Thank you sir. It worked.