Remove ' from table

Question

Sarah Yun 2019-12-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498244-remove-from-table

回答： 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

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.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Cris LaPierre 2019-12-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498244-remove-from-table#answer_407944

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.