Whitespace Delimited Textfile, NaN results?

1 次查看（过去 30 天）
Sage Hayes
Sage Hayes 2021-10-28
回答： Walter Roberson 2021-10-28
Hi, so I'm having trouble reading this delimited textfile. It's whitespace delimited columns with rows being indicated by carriage returns.
So far I've been trying to read it through this method:
clear all;
close all;
fid = fopen('test.txt', 'rt');
%make headers
tline = fgetl(fid);
headers = strsplit(tline, ','); %a cell array of strings
%make data
datacell = textscan(fid,'%f%f%f%f', 'Delimiter',' ', 'CollectOutput', 1);
fclose(fid);
datavalues = datacell{1}; %as a numeric array
However this has resulted in a bunch of NaN's inserted into the matrix (Capture.PNG).
Any help would be greatly appreciated.

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

采纳的回答

per isakson
per isakson 2021-10-28
编辑：per isakson 2021-10-28
The problem is caused by 'Delimiter',' ' in
datacell = textscan(fid,'%f%f%f%f', 'Delimiter',' ', 'CollectOutput', 1);
in combination with two spaces between the third and the fourth column in the text file.
Try
datacell = textscan( fid,'%f%f%f%f', 'CollectOutput', 1);
and let Matlab take care of the problem or
datacell = textscan(fid,'%f%f%f%f', 'Delimiter',' ', 'CollectOutput',1, 'MultipleDelimsAsOne',true);

更多回答（1 个）

Walter Roberson
Walter Roberson 2021-10-28
Ran in:
filename = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/781593/test.txt';
datavalues = readmatrix(filename)
datavalues = 16×4
1.0e+05 * -0.0000 0 -0.0000 4.2263 -0.0000 0 -0.0000 4.0334 -0.0000 0 -0.0000 3.9879 -0.0000 0 -0.0000 4.0397 -0.0000 0 -0.0000 4.1445 -0.0000 0 -0.0000 4.2644 -0.0000 0 -0.0000 4.3675 -0.0000 0 -0.0000 4.4280 -0.0000 0 -0.0000 4.4264 -0.0000 0 -0.0000 4.3490

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by