Borrar filtros
Borrar filtros

How to delete rows from a CELL with certain values?

3 visualizaciones (últimos 30 días)
Akhil  Reddy
Akhil Reddy el 9 de Jun. de 2016
Comentada: Jos (10584) el 9 de Jun. de 2016
It has thousands of rows and I want to remove any row with 0 or 99 or 999 in the row 12 and 13

Respuesta aceptada

Jos (10584)
Jos (10584) el 9 de Jun. de 2016
Similar question, similar answer ...
You should be able to modify the code from that one!
If you do not understand it, just ask for some more explanation...
  2 comentarios
Akhil  Reddy
Akhil Reddy el 9 de Jun. de 2016
what if i need to check values from particular column?
Jos (10584)
Jos (10584) el 9 de Jun. de 2016
Fair enough. You can select the columns first:
A_selected = A(:, [ 12 13]) ;
tf = ~any(cellfun(@(x) isequal(x,0) || isequal(x,99),A_selected, 'un',1),2) ;
B = A(tf,:) ;

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Multidimensional Arrays en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by