Reading Text Files with Numbers and String

Question

Hans123 2020-8-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/579240-reading-text-files-with-numbers-and-string

评论： Star Strider 2020-8-14

采纳的回答： Star Strider

data1.txt

在 MATLAB Online 中打开

Hi, this is a common question and I could not find an answer pertaining to my problem

I have attached an excerpt of my textfile in this question

my text file is built like this and I want to extract ID time and C columns, I tried dlmread and textscan but they yield errors, any help appreciated

ID#: 0  time: 6379.937500   A: 0  B: 0.000000 ; C 0.000000
% my current code
fileID = fopen('ni100khz.txt');
A=textscan(fileID, '%s %f %s %f %s %f %s %f %s %s %f %f ');
fclose(fileID);
% it doesn't scan the whole txt file

2 个评论
显示无隐藏无

源樹上林 2020-8-13

readtable ?

Hans123 2020-8-13

data1.txt

Thanks for the reply, I am working with MATLAB 2017 and it is not available for me. I have attached the format of my textfile, hope it helps. I am currently trying textscan but can't make progress

请先登录，再进行评论。

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

Answer 1

Star Strider 2020-8-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/579240-reading-text-files-with-numbers-and-string#answer_479460

编辑：Star Strider 2020-8-13

在 MATLAB Online 中打开

Try this:

fidi = fopen('data1.txt');
A = textscan(fidi, 'ID#: %f time: %f A: %f B: %f C %f', 'Delimiter',{'\t',';'}, 'MultipleDelimsAsOne',1, 'CollectOutput',1, 'EndOfLine','\r\n');
fclose(fidi);

producing:

Am = cell2mat(A)
Am =
          100       4.6563            0            0            0
          100       4.6875            0            0            0
          100       4.6875          614        3.001        30.01

EDIT —

To extract ‘ID#’, ‘time:’ and ‘C’ only:

          A = textscan(fidi, 'ID#: %f time: %f A: %*f B: %*f C %f', 'Delimiter',{'\t',';'}, 'MultipleDelimsAsOne',1, 'CollectOutput',1, 'EndOfLine','\r\n');