Read .csv files in the right order
3 ビュー (過去 30 日間)
古いコメントを表示
Hello, i have a lot of .csv files do read (around 1500) and need to get a value from each. The problem is that the files appear out of the right order. My code:
list = dir('directory.csv');
numFiles = length(list);
for iFile = 1:numFiles
FileName =list(iFile).name;
Data(iFile).FileName = FileName;
end
for i=1:numFiles
A =dlmread(Data(i).FileName,',',[4 1 4 6]); B(i)=A(1,3);
end
plot(B)
The list structure fills as appear in the picture in attachment.
How can i order the right way?
0 件のコメント
採用された回答
その他の回答 (1 件)
Akira Agata
2018 年 7 月 17 日
編集済み: Akira Agata
2018 年 7 月 17 日
Please try the following before the for-loop.
list = dir(fullfile(yourDirectory,'*.csv'));
[~, idx] = sort(str2double(regexp({list.name},'\d+(?=.csv)','match','once')));
list = list(idx);
2 件のコメント
Akira Agata
2018 年 7 月 17 日
Seems strange... But, anyway, it's nice to hear that you now have a solution!
参考
カテゴリ
Help Center および File Exchange で Logical についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!