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