Google Sheets – Using REGEX with Filter

filtergoogle sheetsregexregexextract

I'm trying to mix regex with a filter in Google Sheets. What I have at the moment is

=filter(AD:AD,X:X=X2,right(Z:Z,1)={1,2,3,4,5,6,7,8,9})

The regular expression is that the final character in column Z is a digit between 1-9 but I cannot figure out how to mix the functions.

Any advice would be greatly appreciated!

Try this formula:

=filter(H2:H7,I2:I7=F2,regexmatch(right(J2:J7,1),"[0-9]"))

Sample data

You can use REGEXMATCH:

=IF(REGEXMATCH(A1, "sites"), 1, 0)

To explain, REGEXMATCH returns true if and only if the argument is a substring of your string.

Ok here is what I ended up going with:

=query(B:B, "select *
where
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...?