Problem when importing a TXT file into MATLAB with "readtable". Text and numbers are between single quotes...
4 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
madhan ravi
2019-2-13
编辑:madhan ravi
2019-2-13
T=table2cell(data);
T(:,3:end)=cellfun(@str2double,T(:,3:end),'un',0)
2 个评论
madhan ravi
2019-2-14
It would be better if you ask a separate question by providing all the necessary details, as I have answered your original question.
更多回答(1 个)
Peter Perkins
2019-2-17
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 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!