Whitespace Delimited Textfile, NaN results?

Question

Sage Hayes 2021-10-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1573458-whitespace-delimited-textfile-nan-results

回答： 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.

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

请先登录，再进行评论。

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

Answer 1

per isakson 2021-10-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1573458-whitespace-delimited-textfile-nan-results#answer_818443

编辑：per isakson 2021-10-28

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sage Hayes 2021-10-28

Solved! thank you very much!

请先登录，再进行评论。

Answer 2

Walter Roberson 2021-10-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1573458-whitespace-delimited-textfile-nan-results#answer_818453

在 MATLAB Online 中打开

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