Solved: Regex character extraction - Page 2

Lennard87 · 08-27-2024 01:50 AM

I'm experiencing issues with Regex within a Looker Studio table. I have a table column with a dimension that contains both:

'Product name'
'Product name [id]'

I want to use regex to get rid of the '[id]' portion (in other words, only have the product name).
I managed to get a working expression within a regex tester:

This matches the correct part in this tester, but when trying this within Looker Studio Regex_Extract I get this error message:

So how do I actually extract the product name (with a variable number of characters) from this dimension?

Mehdi_Oudjida

Hey @Lennard87

You need 2 back slashes to espace special characters inside Looker Studio. But for your use case, you can do it differently with this formula:

TRIM(REGEXP_EXTRACT("Product name [26]","^[^[]*")

View solution in original post