Remove ' from table
14 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Walter Roberson
il 28 Dic 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
il 28 Dic 2019
It would be helpful if you uploaded the text files and the code you used to load them into MATLAB.
Risposte (1)
Cris LaPierre
il 28 Dic 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 Commenti
Vedere anche
Categorie
Scopri di più su Text Files in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!