I have a sheet where I don't want to see any rows that contain either a "+" or a "[" in a certain column... Can't figure out how to do that.

The built-in Filter function only lets me add one condition from what I can see, and regex match is just saying "true" or "false" (for some reason I thought it would spit out data that matched... guess not).


Ok here is what I ended up going with:

=query(B:B, "select *
not B contains '-'
and not B contains '+'
and not B contains '""'
and not B contains '['")


But I'm guessing there is a more succinct way of achieving this...?

  • 1
    HAve you tried using the regex in your query? I am =query(B:B, "Select * where A matches '.*/[A-Z,0-9]+/.*' ") I am sure you need more but I am guessing you have the regex already worked out. I have that only as an example. – Karl_S Mar 16 '17 at 18:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.