Remove ' from table

18 views (last 30 days)
Sarah Yun
Sarah Yun on 28 Dec 2019
Answered: Cris LaPierre on 28 Dec 2019
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 Comments
Walter Roberson
Walter Roberson on 28 Dec 2019
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 on 28 Dec 2019
It would be helpful if you uploaded the text files and the code you used to load them into MATLAB.

Sign in to comment.

Answers (1)

Cris LaPierre
Cris LaPierre on 28 Dec 2019
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.

Tags

Community Treasure Hunt

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

Start Hunting!