Filter Strings in Array for Specific Attributes Matlab

Question

I have a column of strings in a table representing the filenames in a folder as produced by the dir function.

tmpList = struct2table(dir('myFolder'));

The folder contains many different file types and folders. I want only the excel files and I can find these by using:

filesData = [dir(['myFolder','\*.xlsx']);dir(['myFolder','\*.xls'])];

However how do I expand this/ replace this such that I can filter tmpList.name to include only files which have the following attributes:

First three letters are: 'DTE' (which occurs as both caps or small case)
All the characters following DTE are only numbers (and only numbers between 6 and 8 characters long)
Extension is .xlsx or .xls

example, for the following list only 1 and 2 are identified to keep:

'DTE123456.xlsx'
'Dte01234567.xls'
'abc12345678.xlsx'
'DTE12345c34.xls'
'DTE123456.doc'

Michał Machnicki · Accepted Answer · 2018-02-06 12:39:15Z

3

You can use regular expression to find file names which meet your criteria and then cellfun to find indexes of those file names in tmpList:

tmpList = struct2table(dir('myFolder')); % your beginning

filteredTmpList = regexpi(tmpList.name(:), '^dte\d{6,8}\.xlsx?$', 'match');
finalList = tmpList(~cellfun('isempty',filteredTmpList), :);

edited Feb 6, 2018 at 12:39

answered Feb 6, 2018 at 12:33

Michał Machnicki

3,0932 gold badges19 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Filter Strings in Array for Specific Attributes Matlab

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related