Remove ' from table
13 次查看(过去 30 天)
显示 更早的评论
Hi,
I used the 'readtable' function to read a textfile in Matlab and every value in every cell now has a ' around it e.g. '2015'
How can I remove the ' from every column - there are 22 columns
![afasfasf.png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/257424/afasfasf.png)
Also, I cannot use readtable function when loading another textfile
Error: All lines of a text file must have the same number of delimiters. Line 4546
has 16 delimiters, while preceding lines have 14.
Please can you help me solve this problem?
Simple solution. I am beginner.
2 个评论
Walter Roberson
2019-12-28
You either failed to skip a header, or else some elements of the column contain text (e.g., "N/A" or "Missing"). It is best to have another look at the file and determine which of the two applies, as the strategies differ between the two.
the cyclist
2019-12-28
It would be helpful if you uploaded the text files and the code you used to load them into MATLAB.
回答(1 个)
Cris LaPierre
2019-12-28
You could try using the Import Data tool to import the data interactively. This would allow you test various settings and see a preview of what the imported data will look like. Once you get it set correctly, generate the code to reuse in your script.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!