Extracting specific data from a cell array

3 vues (au cours des 30 derniers jours)
fadzhi
fadzhi le 1 Fév 2021
Modifié(e) : Stephen23 le 2 Fév 2021
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 Large Files and Big Data dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by