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

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!

[dpb]

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ý]

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:

Answer 1

[Peter Perkins]

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.

[Karel Starý]

I have multiple tables stored in one cell array. The main question is how the condition for deleting should be build. I don’t know how to tell it I need them deleted if ANYTHING is in that row.... Would it be (T.EventLTEEvents) > 0 sufficient for strings?

[Peter Perkins]

You need to base the condition on whatever your definition of "anything " is. It seems like you want to use strlength, as I already showed.

[Karel Starý]

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]

glad to help. we all have our off days.