Problem when importing a TXT file into MATLAB with "readtable". Text and numbers are between single quotes...
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Joseba Moreno
am 13 Feb. 2019
Beantwortet: Peter Perkins
am 17 Feb. 2019
Hello everyone,
I am facing a big issue when trying to read a table from a TXT file. The data appears to be normal in Excel and in Wordpad but not in Matlab. Why does not Matlab recognize numerical data and import it as so?
So far I have the following sequence:
data=readtable('example.txt);
And then I get the following (see picture).
How can I get rid of the single quotes and treat the numerical data (from column 3 on) normally?
I would really appreciate your help in this regard.
Best,
Joseba![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/203998/image.jpeg)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/203998/image.jpeg)
0 Kommentare
Akzeptierte Antwort
madhan ravi
am 13 Feb. 2019
Bearbeitet: madhan ravi
am 13 Feb. 2019
T=table2cell(data);
T(:,3:end)=cellfun(@str2double,T(:,3:end),'un',0)
2 Kommentare
madhan ravi
am 14 Feb. 2019
It would be better if you ask a separate question by providing all the necessary details, as I have answered your original question.
Weitere Antworten (1)
Peter Perkins
am 17 Feb. 2019
The real problem is that there's something funny in your file that you are not telling us about. Part of it may be using comma as the decimal separator (which I think can be addresses using detectimportoptions, part of which is the specific date format, which again can be addressed with detectimportoptions.
But I'm guessing that the main issue is that all the numeric values in your file are quoted.
Normally, readtable in a recent version of MATLAB should read data like what you have with little or no guidance, and you certainly should not have to call str2double all over the place. A SMALL snippet of you file would help others in diagnosing your problem.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Dates and Time finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!