Debugging help needed please :(

4 vues (au cours des 30 derniers jours)
chlor thanks
chlor thanks le 15 Juil 2016
Commenté : chlor thanks le 19 Juil 2016
I am trying to have a loop that extracts all files that do not start with ~$ and ends in xls or xlsx
This is what I have
n = length(list);
%list is an cell array of a list of folders that I have
i = 0; ii=0;
for k = 1 : n
Sub = list{k};
filehunt = fullfile(Sub, '*.xls*');
Excel = dir(filehunt);
%here I use the loop to "dir" all files that contain the keywords .xls
if ~isempty(Excel)
for k2 = 1 : length(Excel)
if strncmp('~$',Excel(k2).name,2)== 0
%here I try to eliminate any files that have ~$ in front
if ~isempty(goodexcel)
for k3 = 1 : length(goodexcel)
if ~isempty(regexp(goodexcel(k3).name, '\.xlsx?$', 'once'));
%here I try to find all files that end in xls or xlsx instead of just having .xls somewhere in the file name
This has not been able to work due to the error:
Subscripted assignment dimension mismatch.
Please enlighten my poor brain with any matlab coding skill/tips.
Thank you for your patience.

Réponse acceptée

Image Analyst
Image Analyst le 15 Juil 2016
Modifié(e) : Image Analyst le 15 Juil 2016
Check this out:
if all(Excel(k2).name(1:2) == '~$')
msgbox('It starts with ~$ so skip this file');
break; % Skip to bottom of loop
msgbox('It does not start with ~$');
  9 commentaires
Image Analyst
Image Analyst le 19 Juil 2016
You can use fileparts() to pull off the last extension
[folder, baseFileNameWithoutExtension, extension] = fileparts(filename);
Then just use extension to see whether to add to the final list.
chlor thanks
chlor thanks le 19 Juil 2016
Although I still have not able to figure out how to get rid of the empty cells returned by the loop. The fileparts() command works great and better than the regexp() I was trying with before. Thank you very much for the helpful info!

Connectez-vous pour commenter.

Plus de réponses (0)


En savoir plus sur Loops and Conditional Statements dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by