How to organize text files by date and time inside folder

Question

ZATLA Hicham 2016-4-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/278378-how-to-organize-text-files-by-date-and-time-inside-folder

评论： Stephen23 2016-4-13

Hello, I have many txt files inside a folder. the txt files had the name format: xxx_xxx_DayName-Number-Month-Year_HH-MM-SS.txt. I need to organize those files by date and time as wrote on the file name from the older to the newest, please help me to solve this problem. Thank you. Hicham ZATLA

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

Stephen23 2016-4-11

编辑：Stephen23 2016-4-11

在 MATLAB Online 中打开

The simplest solution is to rename your files and use an ISO 80601 date, then the files will sort into chronological order using any standard text sort (including the OS's folder display). Any other solution is going to be much more complicated and buggy than if you simply named the files using the world's best date format: ISO 8601.

http://www.mathworks.com/matlabcentral/fileexchange/34095-date-vector-number-to-iso-8601-date-string

Sorting ISO 8601 dates is simple because you don't need to do anything special at all:

>> C = {'2016-02-04';'1999-03-31';'1999-03-29';'2005-05-25'}
C =
2016-02-04
1999-03-31
1999-03-29
2005-05-25
>> sort(C)
1999-03-29
1999-03-31
2005-05-25
2016-02-04

This is a very good example of where good planning makes writing code much easier, and where bad design choices make code more complicated and buggy. You made a choice of filenames that is going to be much more difficult and buggy to sort than if you had used a simple ISO 8601 date format.

请先登录，再进行评论。

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

Answer 1

Muhammad Usman Saleem 2016-4-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/278378-how-to-organize-text-files-by-date-and-time-inside-folder#answer_217407

编辑：Muhammad Usman Saleem 2016-4-11

Try from SORTN - sort textual lists

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

Stephen23 2016-4-13

None of these help with sorting date strings with the order day-month-year. Even if the sort used a natural order sort on the numeric values within the strings, the output would still not be in chronological order.

None of these suggestions actually answer the original question: "I need to organize those files by date and time as wrote on the file name from the older to the newest" They would, at best, sort by numeric values within the strings, which is not the same as the chronological order for the date format used in those date strings.

See my answer for one way to correctly sort date strings into chronological order.

请先登录，再进行评论。

Answer 2

Stephen23 2016-4-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/278378-how-to-organize-text-files-by-date-and-time-inside-folder#answer_217423

编辑：Stephen23 2016-4-11

在 MATLAB Online 中打开

% Create some fake filenames:
V = now - [0:0.987654321:10].';
fmt = 'DDDD-DD-mm-yyyy_HH-MM-SS';
C = cellstr(datestr(V,fmt));
C = strcat('xxx_xxx_',C,'.txt');
C(randperm(numel(C))) = C % randomize!

creates this cell array of filenames, with the dates in a random order:

C = 
xxx_xxx_Saturday-02-04-2016_20-44-14.txt
xxx_xxx_Monday-04-04-2016_20-08-40.txt
xxx_xxx_Sunday-10-04-2016_18-22-00.txt
xxx_xxx_Saturday-09-04-2016_18-39-47.txt
xxx_xxx_Thursday-07-04-2016_19-15-20.txt
xxx_xxx_Wednesday-06-04-2016_19-33-07.txt
xxx_xxx_Friday-01-04-2016_21-02-00.txt
xxx_xxx_Tuesday-05-04-2016_19-50-54.txt
xxx_xxx_Friday-08-04-2016_18-57-34.txt
xxx_xxx_Monday-11-04-2016_18-04-14.txt
xxx_xxx_Sunday-03-04-2016_20-26-27.txt

Now to sort them into chronological order we can do this:

D = regexp(C,'[^_]+_[^_]+_(.*)\.txt','once','tokens');
N = datenum(vertcat(D{:}),fmt);
[~,X] = sort(N);
out = C(X)

to get the sorted cell array of filenames:

 out =
  xxx_xxx_Friday-01-04-2016_21-02-00.txt
  xxx_xxx_Saturday-02-04-2016_20-44-14.txt
  xxx_xxx_Sunday-03-04-2016_20-26-27.txt
  xxx_xxx_Monday-04-04-2016_20-08-40.txt
  xxx_xxx_Tuesday-05-04-2016_19-50-54.txt
  xxx_xxx_Wednesday-06-04-2016_19-33-07.txt
  xxx_xxx_Thursday-07-04-2016_19-15-20.txt
  xxx_xxx_Friday-08-04-2016_18-57-34.txt
  xxx_xxx_Saturday-09-04-2016_18-39-47.txt
  xxx_xxx_Sunday-10-04-2016_18-22-00.txt
  xxx_xxx_Monday-11-04-2016_18-04-14.txt

2 个评论
显示无隐藏无

Stephen23 2016-4-12

ZATLA Hicham's "Answer" moved here:

Thank you all for your reply. I think my question it was not clear, I want to sort the txt files _ inside the folder (example datas)_ not only sort them in the output name of Matlab, so when the Matlab give me the first name txt file I want also to copy this file and past it in the folder now the same for the next file with copy and past the file after the first file inside the folder and so on.

Stephen23 2016-4-12

编辑：Stephen23 2016-4-12

@ZATLA Hicham: The sorting of the files inside the folder has nothing to do with MATLAB: this depends on your operating system or file manager.

The simplest solution (which is most likely to work) is exactly as I explained in my comment to your question: use an ISO 8601 date format. Then probably most OS's will display the dates in the correct order.

请先登录，再进行评论。