How to remove rows in table that have empty values
38 views (last 30 days)
Show older comments
I have the following tables with two columns
Look at the second last and third last rows, see how the right column has values []
I want to remove all rows within the table that have that value []
My main objectives is to sort the table by the right column, however, i cannot because it errors "Some cells in X contain non-scalar values and cannot be sorted."
So i'm thinking if i can remove all rows of data that have the values [], then i can sort it.
Please inform how I can do this
'A' 52201554
'B' 2130725
'C' 138307808
'AAC' 1220000
'AAC.U' []
'AAC.WS' []
'AAIC' 121888
1 Comment
Image Analyst
on 23 Sep 2021
Attach a sample table with empty row(s) in a .mat file with the paperclip icon.
Answers (1)
See Also
Categories
Find more on Cell Arrays 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!