Delete Rows of an Array where a given column is less (or greater) than a given value

Hello!

With an array like this:

A=     4     2     3
       1     6     5
       1     2     9
       5     2     2
       1     2     6

I would like to have an array with (for example) column 3 less than 5. I know that sortrows(A,3) can get the rows in order, but what is the (logical?) test to eliminate these rows?

Thanks!

Doug

[Douglas Anderson]

Just to be clear! I mean that the VALUE of column 3 is less than 5!

Answer 1

[Star Strider]

To eliminate the rows with the value of column 3 less than 5, keep those with the value of column 3 greater than or equal to 5:

A = A(A(:,3) >= 5, :)

similarly:

A(A(:,3) < 5, :) = []

will both produce:

A =

       1     6     5
       1     2     9
       1     2     6

Is this what you want to do?

[Douglas Anderson]

Yes! Thank you. I just don't want to put the smiley face as :) = [] !

[Star Strider]

LOL! My pleasure!

[WENDY ZHANG]

Really helpful!

[William McMillan]

I have a 39801x7 array and i would like to keep any row that has a value greater than 5 or value less than -5. How would I do this?