delete or keep special rows in a cell array based on specific column values
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Shima Asaadi
am 3 Apr. 2016
Kommentiert: Shima Asaadi
am 3 Apr. 2016
I have a cell array with 2 columns. first column is array of strings, and second is numeric values. I would like to delete the rows in which the first column does not contain \w & \s at all using reqexprep. example of cell array:
'summits,' '-1'
'.' ' 3'
'greenhouse' ' 0'
'hello world' '-2'
'abandoned' '-2'
But, I have 2 problems:
- Item two how to delete the whole row which satisfies the condition, like the second row in example which contains '.' in the first column,
- how to keep a row which just have additional "," in the first column, like the first row in example(I mean that I want to delete ',' and keep 'summits' and its row)! It's a bit complicated!!
I would appreciate any help,
Thank you in advance
0 Kommentare
Akzeptierte Antwort
Azzi Abdelmalek
am 3 Apr. 2016
A={'summits,' '-1'
'.' ' 3'
'greenhouse' ' 0'
'hello world' '-2'
'abandoned' '-2'}
d=cellfun(@(x) regexprep(x,'[,\.]',''),A(:,1),'un',0)
idx=cellfun(@isempty,d)
A(:,1)=d
A(idx,:)=[]
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu MATLAB Report Generator finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!