Effacer les filtres
Effacer les filtres

Whitespace Delimited Textfile, NaN results?

2 vues (au cours des 30 derniers jours)
Sage Hayes
Sage Hayes le 28 Oct 2021
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.

Réponse acceptée

per isakson
per isakson le 28 Oct 2021
Modifié(e) : per isakson le 28 Oct 2021
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 commentaire
Sage Hayes
Sage Hayes le 28 Oct 2021
Solved! thank you very much!

Connectez-vous pour commenter.

Plus de réponses (1)

Walter Roberson
Walter Roberson le 28 Oct 2021
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

Catégories

En savoir plus sur Large Files and Big Data dans Help Center et File Exchange

Produits


Version

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by