Data Studio
4.9K members online now
4.9K 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
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.