importing an empty text column rather than a number column
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Afolabi Fashola
am 10 Aug. 2020
Kommentiert: Afolabi Fashola
am 14 Aug. 2020
Hello,
I have a excel spreadsheet with 12 columns that I imported into MATLAB using readtable. The issue is there are two text columns which could sometimes be empty and sometimes not. Whenever its empty and i run the code MATLAB imports the table and replaces the empty cells with NAN showing its not a text column but i want it to be replaces with single qoutes (' ') instead because it is a text column.
2 Kommentare
Stijn Haenen
am 10 Aug. 2020
Use the num2str command and change every NaN to ' ':
Data=num2str(Data);
Data(Data=='NaN')=' ';
Akzeptierte Antwort
J. Alex Lee
am 11 Aug. 2020
Are you already using something like detectImportOptions() or spreadsheetImportOptions()? If not, look at that
And then look at setVarType().
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!