using natsortfiles to import csv files correctly

8 次查看(过去 30 天)
I have been looking for a way to import many csv files into matlab in the correct order (e.g. csv1, csv2, csv3).
My csv files have a naming structure of c0_1f0_1_0.csv, c0_1f0_1_1.csv etc. Where I want them ordered by the last digit.
I have found the function natsortfiles and have downloaded this from the file exchange and saved it into my working folder, but I am new to this and I am struggling to get it to work in my script from here. Is there anything I am missing or doing wrong?
P = 'E:.....';
S = dir(fullfile(P,'*.txt'));
C = natsortfiles({S.name});
for k = 1:numel(C)
fullfile(P,C{k})
end
  3 个评论
C.G.
C.G. 2021-2-10
sorry for wording my question so confusingly. I have 1000 files, so i want to sort them by the last number.
I have downloaded the zip file from the file exchange, extracted it and put it in my working folder. I am trying to use the code above but it says that natsort files does not exist, so I meant do I have to import anything else before I do this line?
Stephen23
Stephen23 2021-2-10
"but it says that natsort files does not exist"
All of the required files are in the downloaded zip file (you need both NATSORT and NATSORTFILES).

请先登录,再进行评论。

回答(1 个)

Stephen23
Stephen23 2021-2-10
编辑:Stephen23 2021-4-18
Taking a guess that you actually want to match the last integer, not just the last digit:
S = natsortfiles(S,'\d+^$'); % alphanumeric sort by filename
Remove the plus if you really just want the last digit.
  4 个评论
C.G.
C.G. 2021-2-10
Thankyou I have got this to work now I have sorted the search path.
Just another question. In the code below, S reads all the files into matlab, and then after that the names are sorted into number order saved in C, but this does not rearrange the files in the structure. If i now manipluate this data more in matlab will it continue to read the files in the correct name order?
P = 'E:...';
S = dir(fullfile(P,'*.csv'));
C = natsortfiles({S.name});
for k = 1:numel(C)
a = fullfile(P,C{k})
end
Stephen23
Stephen23 2021-2-11
编辑:Stephen23 2021-4-18
"...but this does not rearrange the files in the structure"
NATSORTFILES will sort a cell array of filenames, but can also sort the DIR structure directly:
>> S = dir('*.txt');
>> S.name
ans =
'1.txt'
ans =
'10.txt'
ans =
'2.txt'
>> S = natsortfiles(S);
>> S.name
ans =
'1.txt'
ans =
'2.txt'
ans =
'10.txt'

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 File Operations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by