Remove equal sign and quotation marks in readtable
조회 수: 20(최근 30일)
I am trying to read a csv file that includes both text and numbers. Here is a screenshot of the file.
I am using the following command:
tmp = readtable('file.csv','Format','auto','ReadVariableNames',0);
The tmp file is full of equal signs and quotation marks, which are indeed in the csv file, but are not displayed in excel. For some reason, when I run the same code on a different machine, the tmp file looks much nicer because it does not have the quotation marks and equal signs. I don't know if that is due to the way matlab or excel are setup. In both cases, it's Matlab 2020b.
Is there a possibility to always remove the equal signs and quotation marks when reading the table? I am looking for a robust solution that ensures that the code can be run on different machines.