Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • $\begingroup$ Per my comment to Kguler, could you clarify: do you mean in your example any rows with columns other than second or third with a value greater than the second or third, or are you interested in only checking against one column? $\endgroup$ Commented Jun 3, 2014 at 23:37
  • $\begingroup$ Sorry for this late response and the confusion. I meant second or third column (for that matter any column) containing a value which is larger than a particular value (e.g. 10, etc). Your suggestion is very exciting. $\endgroup$ Commented Jun 5, 2014 at 22:11
  • $\begingroup$ OK, I'm actually more confused re-reading your OP and reply. Say a row is {1,2,3,4,5,6,7} (element is col number in this case). Is it that you want to specify some value, and then remove rows where only certain columns you specify have a value exceeding that, or is it you want to specify some columns, and delete any rows where any of the other columns in the row have a value exceeding any of the values in the specified columns (what I answered)? $\endgroup$ Commented Jun 5, 2014 at 22:18
  • $\begingroup$ I went ahead and updated my post with the alternative interpretation... let me know if that's what you meant. $\endgroup$ Commented Jun 5, 2014 at 22:29
  • $\begingroup$ I want to specify some value, and then remove rows where only certain columns I specify have a value exceeding that. Sorry for all the confusions! the other interpretation of my OP sounds too complicated :). But then I am not sure I was clear $\endgroup$ Commented Jun 6, 2014 at 16:30