Advanced filter - starts with a certain pattern of letters and numbers

[LawrenceK]

We need to filter a look by a specific account number pattern: it starts with the letter H and then is following by a number (0-9). There are lots of account numbers that start with H, two additional letters, then numbers.

In PostgreSQL, I can easily do it by doing … WHERE account_number ~ E'^{1}[0-9]+'

I cannot find a way to do such a thing in the advanced filter in Looker. Currently, I’m simply doing… account_number starts with H1 H2 H3 H4 H5 H6 H7 H8 H9 H0

Is there a more elegant solution? I need to do this again for an additional scenario where it starts with any letter then either 2 or 3 numbers. (In PostgreSQL, it’s E'^[aA-zZ]{2,3}[0-9]+')