Need to find files in a dir structure with similar but not identical names
21 views (last 30 days)
I am trying to pull data from multiple files in a directory. I have written a for loop to get to the specified file, but when I search for the file using an * is cannot be found. For example, the file name 072814_Nominal.xls and another file in the same directory might be called 081213_Nominal.xls. I want to pull date from only files with "Nominal" in the name. I have tried using the below loop
if D(i).name=='*Nominal.xls' %this line is trouble - says matrix dimensions must agree
but I am getting the "Error using ==", "matrix dimensions must agree" error and I cannot find a way to make Matlab find the file that looks like 'Nominal' or 'Nominal.xls' (I have tried both). Please help!
Ahmet Cecen on 29 Jul 2014
Look for an implementation of grep or agrep for MATLAB. However if your problem has a monotonic redundancy, I might be able to suggest an alternative. For example, if you are only concerned about files ENDING with a very specific name (without possibility of spelling errors) such as '_nominal.xls', then here is a very lazy way to do it.
files = dir('*.xls');
for k = 1:length(files)
images = cell(1, length(list));
for k = 1:length(list)
Now only files whose name has the last 11 characters exactly 'nominal.xls' is loaded into the cell data.
More Answers (3)
Image Analyst on 29 Jul 2014
use strfind() instead
if ~isempty(strfind(D(i).name, 'Nominal.xls')) % Don't use *Nominal use Nominal
per isakson on 29 Jul 2014
D = dir( fullfile( pathname, '*Nominal.xls' ) );
for jj = 1 : length(D)
filespec = fullfile( pathname, D(jj).name );
temp(jj) = xlsread( filespec, 'Sheet1','R4');
John on 29 Jul 2014
Hi. I would like to add one piece of advice. In MATLAB, string comparisons for the purposes of logical testing are best done with 'strcmp'. You likely got that matrix dimensions error because strings in MATLAB are character arrays and if the filenames have different lengths then so will the character vectors that represent them. Strcmp, strfind, etc... are the way to go for string comparisons.