Debugging help needed please :(

1 次查看（过去 30 天）

显示更早的评论

chlor thanks 2016-7-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/295940-debugging-help-needed-please

评论： chlor thanks 2016-7-19

采纳的回答： Image Analyst

在 MATLAB Online 中打开

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)
            ii=ii+1;
            if strncmp('~$',Excel(k2).name,2)== 0 
               goodexcel(ii)=Excel(k2).name;
%here I try to eliminate any files that have ~$ in front
               if ~isempty(goodexcel)           
                  for k3 = 1 : length(goodexcel)
                        i=i+1;
                        if ~isempty(regexp(goodexcel(k3).name, '\.xlsx?$', 'once'));
                            ExcellentExcel(i)=goodexcel(k3).name
%here I try to find all files that end in xls or xlsx instead of just having .xls somewhere in the file name
                        end
                    end
                end
            end
        end
    end   
end

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.

采纳的回答

Image Analyst 2016-7-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/295940-debugging-help-needed-please#answer_228796

编辑：Image Analyst 2016-7-15

在 MATLAB Online 中打开

Check this out:

if all(Excel(k2).name(1:2) == '~$')
  msgbox('It starts with ~$ so skip this file');
  break; % Skip to bottom of loop
else
  msgbox('It does not start with ~$');
end

9 个评论
显示 7更早的评论隐藏 7更早的评论

Image Analyst 2016-7-19

在 MATLAB Online 中打开

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 2016-7-19

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!

请先登录，再进行评论。