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

REGEXP_EXTRACT

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I am trying to get the hashtags from the text message using regexpextract function. 

 

REGEXP_EXTRACT(message,'(#\w+)')

 

It works fine outside the Data Studio. Can anyone please help me out to solve this problem.

 

Thanks,

Divya

1 Expert replyverified_user

REGEXP_EXTRACT

Google Employee
# 2
Google Employee

Hi Divya -- I'm not a regular expression expert but will try to help! The REGEXP_EXTRACT Help Center article has some usage notes including about how the function uses RE2-style regular expressions so please review those.

 

Otherwise: are you able to get the function to work with simpler capture regex? Wondering if the entire function doesn't work for you or just when the statement becomes more complex.