Data Studio
6.5K members online now
6.5K 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!