how to delete empty entry from a table

2 visualizzazioni (ultimi 30 giorni)
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

Risposta accettata

Azzi Abdelmalek
Azzi Abdelmalek il 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,:)=[]

Più risposte (0)

Categorie

Scopri di più su Tables in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by