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'^
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]+')