Open Files by File Name Patterns

Question

chlor thanks 2016-7-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/293359-open-files-by-file-name-patterns

评论： chlor thanks 2016-7-1

I am looking for the best Syntax to recognize patterns in file names and open the desired files/filter out unwanted files.

For example,

I have files named

HI_1C_TTTT4_468.xlsx
HI_2C_TTTT9_456.xlsx
HI_8C_TTTT7_279_Plot.xlsx
HI_5678_5487.xlsx

and I only wish to open the first two files, which have similar patterns unlike the last two. Any advice/examples?

Thank you!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Guillaume 2016-7-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/293359-open-files-by-file-name-patterns#answer_227382

编辑：Guillaume 2016-7-1

在 MATLAB Online 中打开

regular expressions seem like the perfect candidate. In your case:

s = {'HI_1C_TTTT4_468.xlsx';
     'HI_2C_TTTT9_456.xlsx';
     'HI_8C_TTTT7_279_Plot.xlsx';
     'HI_5678_5487.xlsx'}
ismatch = ~cellfun(@isempty, regexp(s, '^HI_\dC_TTTT\d_\d{3}\.xlsx$', 'match', 'once'))

is one way to do it.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Guillaume 2016-7-1

在 MATLAB Online 中打开

for filename = s(ismatch)' %transpose since for iterates over columns
   filename  = filename{1}; %extract string from cell
   %do something with filename
   %...
end

chlor thanks 2016-7-1

Thanks!

请先登录，再进行评论。

Answer 2

Thorsten 2016-7-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/293359-open-files-by-file-name-patterns#answer_227385

编辑：Thorsten 2016-7-1

在 MATLAB Online 中打开

find(cell2mat(regexp(names, 'HI_\dC_TTTT\d_\d{3}\.xlsx', 'start')))

\d matches a digit, \d{3} matches 3 digits, \. matches "." (. needs to be escaped with \ because . matches any character)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

chlor thanks 2016-7-1

Thank you so much!! This helps a lot with your explanation! In this case, which syntax will then allow me to open these excels with to later import plots from? Sorry for asking all these dumb questions, I really appreciate your guide on this!

请先登录，再进行评论。

Answer 3

dpb 2016-7-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/293359-open-files-by-file-name-patterns#answer_227384

在 MATLAB Online 中打开

Not amenable to the Matlab incarnation of the dir function, unfortunately--TMW has only implemented the '*' wildcard matching portion and there's not enough uniqueness of the proper type to differentiate the given list.

Your choices boil down to various ways of returning the list with what is partially desired and then winnow it down. Alternatives there vary from in this case you could simply look for those of the proper length(name) (not very robust) to writing a regexp parsing expression to make the match more specific and any number of variations in between regarding partial pattern matches.

Or, depending on the OS shell used, there may be the facilities within the OS to do better pattern matching and so return the desired list from a system call.

You can start in Matlab with

d=dir('HI*TTTT*.xlsx');

and winnow it down to the first three to sift through, but that's about the best Matlab itself can do for the starters.