Writing a loop for processing the data in multiple text files in a folder
1 view (last 30 days)
Show older comments
I'm attempting to process data from a folder with multiple text files, I want to take specific rows/columns from said text files and by applying the reshape/mean function I want to process each text file into a new set of data and write it into a new text file.
Files = dir('C:\Users\lukeaskew\Documents\MATLAB\SpineParametersData');
N = length(Files)
% loop for each file
for i = 1:N
thisfile = Files(i).txt;
AvLx = mean(reshape(thisfile(1:168, 2),28, []));
AvLy = mean(reshape(thisfile(1:168, 3), 28, []));
AvHx = mean(reshape(thisfile(179:192, 2), 14, []));
AvHy = mean(reshape(thisfile(179:192, 3), 14, []));
D = reshape(Avx,6,1);
E = reshape(Avy,6,1);
F = reshape(AvHx,1,1);
G = reshape(AvHy,1,1);
H = [D(:), E(:)];
I = [F(:), G(:)];
J = cat(1,H,I)
writematrix(J,'C:\Users\lukeaskew\Documents\MATLAB\SPDav\%d.txt', i)
end
The issue I am having is that when I print the value of N I get 0 and so the loop does not run through the folder, nor does it ultimately produce the datasets I require.
1 Comment
Stephen23
on 25 Nov 2021
Probably you should specify a filename with widlcard characters, e.g.:
P = 'C:\Users\lukeaskew\Documents\MATLAB\SpineParametersData';
S = dir(fullfile(P,'*.txt'));
for k = 1:numel(S)
F = fullfile(P,S(k).name);
..
end
Answers (1)
Shanmukha Voggu
on 29 Nov 2021
Hi Luke,
Adding to Stephen, In order to explore a similar type of example to get a better idea about looping through text files
0 Comments
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!