Regexp to filter file names
71 ビュー (過去 30 日間)
古いコメントを表示
Hello,
I would like to use a regexp to filter file names contained in a folder. I almost got it, but I have trouble handling cell that output the dir() function...
Let's imagine I have these files in the data folder :
DY463269-F 01-01-2017.xlsx
DY463269-F 01-01-2017.xlsx
DY463271-8 01-01-2017.xlsx
DY466290-M 01-01-2017.xlsx
My code is :
filesList = dir('data/');
serialList = regexpi({filesList.name}, '[a-z]{2}[0-9]{6}[a-z\-]{0,2}', 'match')
dateList = regexpi({filesList.name}, '[0-9]{2}-[0-9]{2}-[0-9]{2}', 'match')
data = cell2struct([serialList; dateList],{'Name','Date'},1)
data(3).Name
First, I guess we can do only one regexpi to get both information... But mostly, data(3).Name return me a cell and I would like it to simply be a string.
Any idea to fix this?
Thanks,
Max
0 件のコメント
採用された回答
Walter Roberson
2017 年 10 月 19 日
filenames = {'DY463269-F 01-01-2017.xlsx'
'DY463269-F 01-01-2017.xlsx'
'DY463271-8 01-01-2017.xlsx'
'DY466290-M 01-01-2017.xlsx'};
fileinfo_cell = regexpi( filenames, '^(?<serial>[a-z]{2}\d{6}[a-z\-]{0,2})\s+(?<date>\d\d-\d\d-\d\d)', 'names','lineanchors');
fileinfo = vertcat(fileinfo_cell{:});
fileinfo will then be a struct array with fields "serial" and "date".
With that particular set of data, the struct will have 3 elements, because DY463271-8 01-01-2017.xlsx does not match the pattern (the serial ends in -8 but the pattern does not permit numbers at that point.)
A generalization of the pattern would be
fileinfo = regexpi( filenames, '^(?<serial>\w\w\d{6}[\w-]{0,2})\s+(?<date>\d\d-\d\d-\d\d)', 'names','lineanchors')
Each \w corresponds to [a-z0-9_] -- the "word-building" characters. What you have now is more focused and you might need that focus, but sometimes it is useful to be more lenient.
その他の回答 (1 件)
Guillaume
2017 年 10 月 19 日
Note that the reason you get cell arrays in your structure is because as you've used it regexpi returns a cell array of cell arrays of char arrays as there can be more than one match per filename. Adding the 'once' option to these regexpi calls would tell them that there can only ever be more than one match and as a result you'd get a cell array of char arrays, which would give you the structure you expect.
serialList = regexpi({filesList.name}, '[a-z]{2}[0-9]{6}[a-z\-]{0,2}', 'match', 'once');
dateList = regexpi({filesList.name}, '[0-9]{2}-[0-9]{2}-[0-9]{2}', 'match', 'once');
参考
カテゴリ
Help Center および File Exchange で File Operations についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!