How can I replace "" entries in a table?
3 views (last 30 days)
Show older comments
Kamal Premaratne
on 28 May 2020
Commented: Kamal Premaratne
on 28 May 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.
0 Comments
Accepted Answer
More Answers (0)
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!