How to remove <missing> from a cell array, possibly replace with blank space

3 vues (au cours des 30 derniers jours)
Gaurav Kumar
Gaurav Kumar le 12 Jan 2019
Commenté : Gaurav Kumar le 12 Jan 2019
Originally I imported text (mixed numeric and alphabets/strings) from a file as a table data.
Since the amount of text/data in different lines of the file is different, many of the elements in the table are NaN.
Now I want to write certain specific lines of this table to another file, but I don't want NaN to be written, instead just leave blank space there
What I tried:
fin = strcat(path_in,'/test.txt'); %input filename
file_data = readtable(fin) ; % read data from the file "fin"
bonds_text= (table2cell(file_data(191:end,:)));
bonds_text(cellfun(@isnan,bonds_text,'UniformOutput',false)) = {[]};
When I try to perform the last line operation, which is to remove NaN by a blank space, it gives me the following error:
Function 'subsindex' is not defined for values of class 'cell'.
I am attaching the file from which I am reading the data
Can you please help me fix this error, or is there another better/simpler way of doing this?
Thank you
  3 commentaires
Gaurav Kumar
Gaurav Kumar le 12 Jan 2019
Thank you very much Walter.
I had actually tried doing the same earlier, and it was giving me an error, but now I corrected my mistake there.
bonds_text= fillmissing(bonds_text,'constant',''); % wrong, single quote, not a string
bonds_text= fillmissing(bonds_text,'constant',""); % correct, double quote, a string

Connectez-vous pour commenter.

Réponses (0)

Catégories

En savoir plus sur Cell Arrays dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by