Question

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

  • 9 August 2022
  • 0 replies
  • 12 views

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!

Reply