Remove ' from table

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.

[Walter Roberson]

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]

It would be helpful if you uploaded the text files and the code you used to load them into MATLAB.

Answer 1

[Cris LaPierre]

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.