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

  • 9 August 2022
  • 0 replies

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

0 replies

Be the first to reply!