How can I replace "" entries in a table?

1 view (last 30 days)
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
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.

Accepted Answer

madhan ravi
madhan ravi on 28 May 2020
  1 Comment
Kamal Premaratne
Kamal Premaratne on 28 May 2020
This works perfectly. Thank you so much Madhan.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!