creating a list of strings with different numbers and same letters

Question

void22 2018-6-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406609-creating-a-list-of-strings-with-different-numbers-and-same-letters

编辑： Stephen23 2021-4-18

采纳的回答： Stephen23

在 MATLAB Online 中打开

i have a folder with files named as follows: f0K.csv f1K.csv f2K.csv and so on...

i want to create a for loop that will assign the data inside each file to a matrix using xlsread somthing like this :

if true
  % code
for i = 0:100
MyFiles(i,:) = xlsread('f*i*K.csv','E1:E2500');
end
end

i know that there is an option to do so but haven't found it (i probably just don't know how to search! ) also , i know it's easy to do with dir('MyFolder') but for some mysterious reason its not working (i made sure its in the path ) so i'm trying to pass that obstacle in adifferent way

would appreciate your kind help !!!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stephen23 2018-6-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406609-creating-a-list-of-strings-with-different-numbers-and-same-letters#answer_325500

编辑：Stephen23 2021-4-18

在 MATLAB Online 中打开

This is easy using sprintf:

D = 'MyFolder';
for kk = 0:100
    fnm = fullfile(D,sprint('f%dK.csv',kk));
    MyFiles(kk+1,:) = xlsread(fnm,'E1:E2500');
end

Or using dir and my FEX submission natsortfiles to get the correct numeric order:

D = 'MyFolder'
S = dir(fullfile(D,'f*K.csv'));
S = natsortfiles(S); % alphanumeric sort by filename
for k = 1:numel(S)
    F = fullfile(D,S(kk).name;
    MyFiles(k,:) = xlsread(F,'E1:E2500');
end