how to remove rows have ' - ' in their columns?

1 view (last 30 days)
chocho
chocho on 20 May 2017
Edited: Jan on 21 May 2017
Hi Friends, i have a cell array of size (37080*2) and i want to delete the rows have '-' in column 1 or 2.
cell={'gif','ghf';'feh','-';'ACACA','BRCA1';'-','TBCD';'NKX3-1','ATXN1'}
Output wanted={'gif','ghf';'ACACA','BRCA1';'NKX3-1','ATXN1'}
i have tried ismember and strcmp but i get only one column vector

Accepted Answer

Jan
Jan on 21 May 2017
Edited: Jan on 21 May 2017
index = strcmp(C(:,1), '-') | strcmp(C(:,2), '-');
C(index, :) = [];
Or:
index = any(strcmp(C, '-'), 2);

More Answers (0)

Categories

Find more on 元胞数组 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!