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
4K members online now
4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

regex_extract

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm trying to extract the third word of an expression.  Outside of data studio:

 

(?:\S+\s+){3}(\S+)

 

works fine.  Inside data studio, I get "Could not parse formula."  How do I extract the third word (which happens to also be the second email address) in my expression?

 

Thank you!

regex_extract

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Figured it out.  The backslashes need to be escaped?!?

 

(?:\\S+\\s+){3}(\\S+)

 

Works great!