Need an Elegant Sorting Solution for Directory File Names

1 view (last 30 days)
I have a directory of filenames, (within a files structure array) structured like this:
cdef2.20140101.pdef.txt
cdef2.20140102.pdef.txt
....
pdef.gdef.201300101-20130105.txt
pdef.gdef.201300106-20130110.txt
....
I need to reorder these (ascending order from oldest to newest) according to the dates embedded within these file names which are formatted like YYYYMMDD. I've explored several options, but I'm seeking an elegant solution without do loops. Any tips or suggestions would be appreciated.
  3 Comments
John Cruce
John Cruce on 9 Jul 2023
Needing to sort by the first date in pdef.gdef.201300101-20130105.txt (i.e., 20130101). I considered running a shell script to rename the files but trying not to add another step.
Sandeep Mishra
Sandeep Mishra on 9 Jul 2023
Can we assume that there exist only two type of files?
One which starts with cdef2 and one which starts with pdef?

Sign in to comment.

Accepted Answer

Voss
Voss on 9 Jul 2023
Edited: Voss on 9 Jul 2023
filenames = { ...
'cdef2.20140101.pdef.txt'; ...
'cdef2.20140102.pdef.txt'; ...
'pdef.gdef.20130101-20130105.txt'; ...
'pdef.gdef.20130106-20130110.txt'}
filenames = 4×1 cell array
{'cdef2.20140101.pdef.txt' } {'cdef2.20140102.pdef.txt' } {'pdef.gdef.20130101-20130105.txt'} {'pdef.gdef.20130106-20130110.txt'}
dates = regexp(filenames,'\d{8}','match','once');
[~,idx] = sort(dates);
sorted_filenames = filenames(idx)
sorted_filenames = 4×1 cell array
{'pdef.gdef.20130101-20130105.txt'} {'pdef.gdef.20130106-20130110.txt'} {'cdef2.20140101.pdef.txt' } {'cdef2.20140102.pdef.txt' }

More Answers (0)

Categories

Find more on File Operations in Help Center and File Exchange

Products


Release

R2023a

Community Treasure Hunt

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

Start Hunting!