Matlab: select data from many DAT files and put them into one file

2 views (last 30 days)
I need to put a specific data of each file together in order, but I don't know what to use to describe its path. For example, all files have only numbers. I need to put the data in the first row and the sixth column of each file together. Maybe I need to use the for loop, but it is too difficult for me.please write a short piece of code.

Accepted Answer

Mathieu NOE
Mathieu NOE on 9 Dec 2022
hello
try this , it will loop in your folder and load all dat files
I assumed here readmatrix is the right function to read your file format
%% define path
fileDir = pwd; % or your specific path / folder
S = dir(fullfile(fileDir,'*.dat')); % get list of data files in directory
S = natsortfiles(S); % sort file names into natural order (what matlab dir does not well) , see FEX :
%(https://fr.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort)
%% Loop inside folder
for k = 1:length(S) % read data in specified sheet
fileName = S(k).name;
out = readmatrix(fullfile(fileDir, fileName)); % or use a structure (S(k).data ) to store the full data structure
end
  2 Comments
ke
ke on 9 Dec 2022
thank you, if I want the data in the first row and sixth column of each dat file, where should I put (1,6)?
Mathieu NOE
Mathieu NOE on 9 Dec 2022
data in the first row = out(1,:)
data in the sixth column = out(:,6)

Sign in to comment.

More Answers (0)

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!