Remove ' from table
14 views (last 30 days)
Show older comments
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 Comments
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
on 28 Dec 2019
It would be helpful if you uploaded the text files and the code you used to load them into MATLAB.
Answers (1)
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.
0 Comments
See Also
Categories
Find more on Text Files in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!