How to read a txt file with comma, text and numbers in matlab, and export the data
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
The txt file I exported from the analysis software contains commas and text and numbers (as shown in the figure below). This prevents me from directly using load data
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/780363/image.png)
The above txt file can be imported into excel using [Data Analysis Wizard] to split it into multiple cells, but I have thousands of these files, I can’t extract data from excel one by one, I want to use more automated Way to extract.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/780368/image.png)
0 commentaires
Réponse acceptée
Walter Roberson
le 27 Oct 2021
See also readtable()
3 commentaires
Walter Roberson
le 28 Oct 2021
clc;
clear all;
% Specify the folder where the files live.
myFolder = 'C:\Users\yourUserName\Documents\My Pictures';
% Check to make sure that folder actually exists. Warn user if it doesn't.
if ~isfolder(myFolder)
errorMessage = sprintf('Error: The following folder does not exist:\n%s\nPlease specify a new folder.', myFolder);
uiwait(warndlg(errorMessage));
myFolder = uigetdir(); % Ask for a new one.
if myFolder == 0
% User clicked Cancel
return;
end
end
% Get a list of all files in the folder with the desired file name pattern.
filePattern = fullfile(myFolder, '**/*.txt'); % Change to whatever pattern you need.
theFiles = dir(filePattern);
num_files = length(theFiles);
t = cell(num_files,1);
for k = 1 : num_files
baseFileName = theFiles(k).name;
fullFileName = fullfile(theFiles(k).folder, baseFileName);
fprintf(1, 'Now reading %s\n', fullFileName);
t{k} = readtable(fullFileName);
end
Plus de réponses (1)
Voir également
Catégories
En savoir plus sur Spreadsheets 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!