How to read a txt file with comma, text and numbers in matlab, and export the data

Question

chihyu 2021-10-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1572608-how-to-read-a-txt-file-with-comma-text-and-numbers-in-matlab-and-export-the-data

评论： chihyu 2021-10-28

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

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2021-10-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1572608-how-to-read-a-txt-file-with-comma-text-and-numbers-in-matlab-and-export-the-data#answer_817468

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

3 个评论
显示 1更早的评论隐藏 1更早的评论

chihyu 2021-10-28

编辑：Walter Roberson 2021-10-28

Hello, I am not sure how I should "readtable" multiple files here

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);
for k = 1 : length(theFiles)
    baseFileName = theFiles(k).name;
    fullFileName = fullfile(theFiles(k).folder, baseFileName);
    fprintf(1, 'Now reading %s\n', fullFileName);
    
    t = readtable('theFiles{k}.name.txt');
end

Walter Roberson 2021-10-28

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