2K members online now
2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

use regex: remove word a label event

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi everyone, I need your help! Smiley Happy

 

I have many event labels with that pattern:

 

Choose template - Sky
Choose template - Sun
Choose template - Beach Club
Choose template - Madrid City

and so on.

 

I need to show in my Google Data Studio report only the words: Sky, Sun, Beach Club,...

 

How can I "to clean" event label for showing just these words without "Choose template - "?

 

A lot of thanks!

use regex: remove word a label event

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

You'll need to create a calculated field with the following formula:

REPLACE(Event Label, "Choose template - ", "")

 

Then use this new field in your tables and graphs.