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

REGEXP_EXTRACT not working in Calculated Field

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm trying to create a Calculated Field by manipulating an existing field exported from Big Query using REGEXP_EXTRACT.

 

Performing REGEXP_EXTRACT(textPayload, '(\d+\.?\d+)') returns either "Could not parse formula" or "Invalid Formula". The regular expression works find outside of Data Studio.

 

FYI, trying to extract the decimal from the following string: "throughput: 33.35"

 

Any ideas?