Extracting specific data from a cell array

Dear all,
I am using following code to read data from multiple text files. So far is okay. Now i wanted to create a matrix that takes entries from the 9th and 11th colum of each cell array A (with changing length due to new text files) and places them after one another. Many thanks for your suggestion and ideas.(Example file is attached)
D = 'T:\New\files';
S = dir(fullfile(D, '*.txt'));
N = length(S);
A = cell(N,1);
fmt = '%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f';
% fmt=repmat('%f',1,2);
for k = 1:N
fid = fopen(fullfile(D,S(k).name), 'r');
A(k)= textscan(fid, fmt, 'Delimiter', '\t', ...
'headerlines', 33, ...
'CollectOutput', 1);
fid=fclose(fid);
end

 Réponse acceptée

Stephen23
Stephen23 le 1 Fév 2021
Modifié(e) : Stephen23 le 2 Fév 2021
After the loop:
M = vertcat(A{:});
out = M(:,[9,11])

Plus de réponses (0)

Catégories

En savoir plus sur Data Import and Analysis dans Centre d'aide et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by