How do I sort filenames containing text and numbers in numerical order in MATLAB?

Question

Brad 2017-10-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/360531-how-do-i-sort-filenames-containing-text-and-numbers-in-numerical-order-in-matlab

编辑： Stephen23 2021-4-18

I have a series of .png files in a folder whose names are the following;

(A)Test_Nom_BAUD1.png
(A)Test_Nom_BAUD7.png
(A)Test_Nom_BAUD8.png
(A)Test_Nom_BAUD10.png
(A)Test_Nom_BAUD11.png

In reading the MATLAB documentation, I understand the dir function sorts strings in ASCII dictionary order. And since the files I'm using have no leading zeros, this is a problem. This is exactly what I'm seeing when I use the dir function:

A = dir('*.png');
(A)Test_Nom_BAUD1.png
(A)Test_Nom_BAUD10.png
(A)Test_Nom_BAUD11png
(A)Test_Nom_BAUD7.png
(A)Test_Nom_BAUD8.png

But what I need is this;

A = dir('*.png');
    (A)Test_Nom_BAUD1.png
    (A)Test_Nom_BAUD7.png
    (A)Test_Nom_BAUD8.png
    (A)Test_Nom_BAUD10.png
    (A)Test_Nom_BAUD11.png

I know this can be done if the filenames contain only numbers.

But is it possible to sort these filenames (in numerical order) using existing text manipulation and sorting routines in MATLAB? If so, how?

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

Stephen23 2018-9-21

编辑：Stephen23 2021-4-18

在 MATLAB Online 中打开

"If so, how?"

Simply download my FEX submission natsortfiles, which was written to solve that exact problem:

S = dir('*.png');
S = natsortfiles(S); % alphanumeric sort by filename

请先登录，再进行评论。

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

Answer 1

Cedric 2017-10-10

12
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/360531-how-do-i-sort-filenames-containing-text-and-numbers-in-numerical-order-in-matlab#answer_285085

编辑：Cedric 2017-10-10

在 MATLAB Online 中打开

If, for any reason, you cannot install this function, you can sort your filenames as follows:

 [~, reindex] = sort( str2double( regexp( {A.name}, '\d+', 'match', 'once' )))
 A = A(reindex) ;

Note that it assumes that all files have the same base name. If you have to deal with various base names, then you need the function mentioned in the other answers, or to work a little more on the sorting.

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

Image Analyst 2018-3-23

You'll have to write a custom parsing routine to extract out the numbers you want into numerical vectors then sort them yourself. Shouldn't be hard but let us know if you can't figure it out.

Stephen23 2018-9-21

编辑：Stephen23 2021-4-18

在 MATLAB Online 中打开

"You'll have to write a custom parsing routine to extract out the numbers you want into numerical vectors then sort them yourself."

You don't have to do that at all: natsortfiles handles multiple number values already. Just provide an appropriate regular expression, and it will work just fine:

>> C = {...
    'RSN1112-KOBE-1.1_Node_Floor_Dsp.out',...
    'RSN1111-KOBE-0.2_Node_Floor_Dsp.out',...
    'RSN1112-KOBE-0.2_Node_Floor_Dsp.out',...
    'RSN1111-KOBE-0.1_Node_Floor_Dsp.out',...
    'RSN1111-KOBE-1.1_Node_Floor_Dsp.out',...
    'RSN1112-KOBE-0.1_Node_Floor_Dsp.out'};
>> natsortfiles(C,'\d+\.?\d*') % alphanumeric sort
ans =
    'RSN1111-KOBE-0.1_Node_Floor_Dsp.out'
    'RSN1111-KOBE-0.2_Node_Floor_Dsp.out'
    'RSN1111-KOBE-1.1_Node_Floor_Dsp.out'
    'RSN1112-KOBE-0.1_Node_Floor_Dsp.out'
    'RSN1112-KOBE-0.2_Node_Floor_Dsp.out'
    'RSN1112-KOBE-1.1_Node_Floor_Dsp.out'