Clear Filters
Clear Filters

how to delete empty entry from a table

4 views (last 30 days)
I have a table consisting of numbers & strings. I need to delete the rows which has empty string value in a particular column. I tried using c.Rollnumber=='' for selecting empty string but getting error.
Thanks

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 13 Apr 2016
%------Example----------------
v={'a' 1 'k';'b' 2 '';'' 1 'v'}
w=cell2table(v)
%------the code---------------
a=table2cell(w)
idx=any(ismember(cellfun(@num2str,a,'un',0),''),2)
w(idx,:)=[]

More Answers (0)

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!