Strip Queries from URLS in Google Data Studio with REGEXP_REPLACE

Question

3k views Asked by Simon Breton At 29 August 2017 at 09:09

I'm trying to build a new calculated field in Google Data Studio to get rid of all the queries. I've tried the following formula:

REGEXP_REPLACE(page,"\?(.*)","")

But Data Studio return me an invalid formula... I guess that's because It's not Google RE2. how do I translate this into Google RE2?

There are 1 answers

**Wiktor Stribiżew** · Accepted Answer · 2017-08-29T12:06:13+00:00

Wiktor Stribiżew On 29 August 2017 at 12:06 BEST ANSWER

You may use

REGEXP_REPLACE(page,"[?].*","")

The pattern will be parsed as a literal ? followed with any 0+ chars, and the whole match will get replaced with an empty string.