How to read text file with float and string types into matrix

Question

Guy Cohen 2020-8-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/584723-how-to-read-text-file-with-float-and-string-types-into-matrix

评论： Guy Cohen 2020-8-27

Hello,

I have a text file with different value types such as string and float. Is there any automatic function to read the file into matrix?

Text file for example:

26/08/2020 08:25:30 $GPS_ABC 100 E 200 M

26/08/2020 08:25:31 $GPS_ABC 101 E 210 M

26/08/2020 08:25:32 $GPS_ABC 102 E 220 M

The only solution i found is:

while ~feof(text_file)
file_data{i}=textscan(text_file,'%f %f %f %f %f %f %s %f %s %f %s',1,'delimiter',['/',':'],'headerlines',1);
i=i+1;
end

Thanks

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

请先登录，再进行评论。

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

Answer 1

Serhii Tetora 2020-8-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/584723-how-to-read-text-file-with-float-and-string-types-into-matrix#answer_485183

在 MATLAB Online 中打开

%% Import data from text file
% Script for importing data from the following text file:
%
% Auto-generated by MATLAB on 26-Aug-2020 14:12:55
%% Setup the Import Options and import the data
opts = delimitedTextImportOptions("NumVariables", 11);
% Specify range and delimiter
opts.DataLines = [1, Inf];
opts.Delimiter = [" ", "/", ":"];
% Specify column names and types
opts.VariableNames = ["VarName1", "VarName2", "VarName3", "VarName4", "VarName5", "VarName6", "VarName7", "VarName8", "VarName9", "VarName10", "VarName11"];
opts.VariableTypes = ["double", "double", "double", "double", "double", "double", "string", "double", "string", "double", "string"];
% Specify file level properties
opts.ExtraColumnsRule = "ignore";
opts.EmptyLineRule = "read";
opts.ConsecutiveDelimitersRule = "join";
% Specify variable properties
opts = setvaropts(opts, ["VarName7", "VarName9", "VarName11"], "WhitespaceRule", "preserve");
opts = setvaropts(opts, ["VarName7", "VarName9", "VarName11"], "EmptyFieldRule", "auto");
% Import the data
text = readtable("text.txt", opts);
%% Clear temporary variables
clear opts