How can I replace "" entries in a table?

3 vues (au cours des 30 derniers jours)
Kamal Premaratne
Kamal Premaratne le 28 Mai 2020
Commenté : Kamal Premaratne le 28 Mai 2020
I imported a large table (300 x 450) and some of the blank entries were imported as "". For the purpose of this question, let me take a part of one column:
>> TT = T(end-4:end,end)
TT =
5×1 table
vm2PR
_____
VC02 ""
VC03 ""
VC04 "6"
VC05 "2"
VC06 ""
How do I replace these "" entries with numerical value 0.0 and the "2" and "6" entries as numerical values 2 and 6 respectively? This has to be done for the whole large table (which is named T). Thank you.

Connectez-vous pour répondre à cette question.

Réponse acceptée

madhan ravi
madhan ravi le 28 Mai 2020
iX=str2double(TT.vm2PR);
TT.vm2PR(isnan(iX))=0
  1 commentaire
Kamal Premaratne
Kamal Premaratne le 28 Mai 2020
This works perfectly. Thank you so much Madhan.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by