Remove ' from table

26 次查看（过去 30 天）
Sarah Yun
Sarah Yun 2019-12-28
回答： Cris LaPierre 2019-12-28
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
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
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
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
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.

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by