delete or keep special rows in a cell array based on specific column values
조회 수: 2 (최근 30일)
이전 댓글 표시
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
채택된 답변
Azzi Abdelmalek
2016년 4월 3일
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,:)=[]
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 MATLAB Report Generator에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!