AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.8K members online now
1.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

REGEXP_REPLACE help needed with GA data

[ Edited ]
Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

I can't get my REGEXP_REPLACE to work.  What am I doing wrong?  I've tried a few different things:

 

Village_Guide_-_Group_report.jpg

 

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Nick G
May 2017

REGEXP_REPLACE help needed with GA data

Google Employee
# 2
Google Employee

Hi Nick

 

At the moment, you need to double escape special characters and classes:

 

"\\|.*"

 

We're fixing this but try the double backslash for now and let me know if that doesn't work for you.

 

Best

 

Rick

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Nick G
May 2017

REGEXP_REPLACE help needed with GA data

Google Employee
# 2
Google Employee

Hi Nick

 

At the moment, you need to double escape special characters and classes:

 

"\\|.*"

 

We're fixing this but try the double backslash for now and let me know if that doesn't work for you.

 

Best

 

Rick

REGEXP_REPLACE help needed with GA data

Follower ✭ ☆ ☆
# 3
Follower ✭ ☆ ☆

Thanks for the quick response Rick!  That worked. It's about the only thing I didn't try.  I have to use the double escape in my ETL tool too.