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

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

Asked:

on 20 May 2017

Edited:

Jan
on 21 May 2017

Community Treasure Hunt

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

Start Hunting!