i am really struggeling with a Regex-Extract in Data Studio.
I want to extract every entry that comes AFTER "SMC-777-"
My data looks like this:
SMC-777-test1
SMC-743-test2sdf
SMC-721-test2wfsd
SMC-777-test91919
Regex everything after SMC-777-
Viewed 47
1 Answers
To extract all characters after SMC-777-, the REGEXP_EXTRACT Calculated Field below does the trick, where Field represents the respective field name:
REGEXP_EXTRACT(Field,"SMC-777-(.*)")
Google Data Studio Report and GIF to elaborate:
Related