I understand that you want to store tables in your txt file into a mat file in such a way that data of the files having same name under different subfolders of the target folder should be clubed together. Following code should help you:
% Define the root folder path
rootFolder = 'path/to/root/folder';
% Initialize an empty cell array to hold the file structs
fileStructs = {};
% Traverse through the root folder and its subfolders
subfolders = dir(rootFolder);
subfolders = subfolders([subfolders.isdir]); % Filter only directories
for i = 1:numel(subfolders)
subfolder = subfolders(i).name;
if strcmp(subfolder, '.') || strcmp(subfolder, '..')
continue; % Skip current and parent directories
end
% Get the list of txt files in the current subfolder
txtFiles = dir(fullfile(rootFolder, subfolder, '*.txt'));
for j = 1:numel(txtFiles)
txtFile = txtFiles(j).name;
% Extract the file name without the extension
[~, fileName, ~] = fileparts(txtFile);
% Check if the file name already exists in the file structs array
fileIndex = find(cellfun(@(x) strcmp(x.name, fileName), fileStructs));
if isempty(fileIndex)
% Create a new file struct and add the table to its list
fileStruct.name = fileName;
fileStruct.tables = {readtable(fullfile(rootFolder, subfolder, txtFile))};
fileStructs{end+1} = fileStruct;
else
% Append the table to the existing file struct's list
fileStructs{fileIndex}.tables{end+1} = readtable(fullfile(rootFolder, subfolder, txtFile));
end
end
end
% Save the file structs cell array as a mat file
save('data.mat', 'fileStructs');
This would store your data in a data.mat file. This would have an array of struct where each struct would have a "name" and "tables" attribute. "table" is an array of tables from the files having same name.
