Delete rows in cell aray where there is anything in one collum.

2 visualizaciones (últimos 30 días)
I have multiple cell arrays and I would like to delete whole rows based on one particular column, if there is anything (text or number) in this column.
Thanks!
  2 comentarios
dpb
dpb el 2 de Ag. de 2021
Make it easier -- attach the sample array as .mat file and tell us which column...I presume the selected one, but yoou don't say so...
Karel Starý
Karel Starý el 3 de Ag. de 2021
Thanks for looking at my question!
You are right, it's the selected one. In this case the name of the variable is EventLTEEvents. Here you have my sample table:

Iniciar sesión para comentar.

Respuesta aceptada

Peter Perkins
Peter Perkins el 3 de Ag. de 2021
A cell array is the wrong way to store these data. You want a table, or probably a timetable. The fact that you say, "the name of the variable is EventLTEEvents" makes me wonder if you already have that. And I recommend that you store text in those tables as string, not as cell arrays of char rows.
Once you have that, deleting rows based on a condition is just subscripting, e.g.
T(T.X > 10,:) = []
In your case, the condition is probably something like strlength(T.EventLTEEvents) > 0.
  4 comentarios
Karel Starý
Karel Starý el 4 de Ag. de 2021
Editada: Karel Starý el 4 de Ag. de 2021
I cannot stress enough how dumb I feel right now. I finally realized how you meant it. String length should definitely work for me. Thank you for your effort.
Peter Perkins
Peter Perkins el 6 de Ag. de 2021
glad to help. we all have our off days.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

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

Etiquetas

Productos


Versión

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by