Google Data Studio: Regular Expressions / REGEX

preview_player
Показать описание
Learn how to create Regular Expressions in Google Data Studio in just. 4 minutes. What you will see in this lesson:

1. What is a regular expression
2. Create your first Regular Expression: REGEXP_MATCH

🎁Additional resources:

Do you want free templates to get started? Access our free Data Studio templates library:

  1. Porter Metrics
  2. google data studio regex
  3. google data studio regex contains
  4. google data studio regex replace
  5. google data studio regex match
  6. Google Data Studio
Рекомендации по теме
Google Data Studio: 0:04:45

Google Data Studio: Regular Expressions / REGEX

How to use 0:23:10

How to use Regular Expressions (REGEX) in Looker Studio (formerly Google Data Studio)

Using Regex Within 0:12:10

Using Regex Within Data Studio: A simple guide

Data Studio - 0:01:13

Data Studio - Regex Match vs Regex Contains

Using Regex Expressions 0:09:55

Using Regex Expressions In Google Data Studio

Clean GA4 acquisition 0:06:38

Clean GA4 acquisition reports with REGEX on Google Looker Studio

Using Regex (Regular 0:38:36

Using Regex (Regular Expressions) with Google Analytics, Tag Manager, & Data Studio

How to use 0:04:49

How to use Regular Expressions on Google Looker Studio for marketing use cases?: Intro to REGEX

Create Custom Fields 0:14:04

Create Custom Fields (RegEx) in Looker Studio (Data Studio)

Google Analytics Tutorial 0:03:40

Google Analytics Tutorial - Regular expressions

How to Use 0:11:49

How to Use Regular Expressions with Google Tag Manager & Google Analytics

Learn Regular Expressions 0:20:52

Learn Regular Expressions In 20 Minutes

REGEX (REGULAR EXPRESSIONS) 0:10:43

REGEX (REGULAR EXPRESSIONS) WITH EXAMPLES IN DETAIL | Regex Tutorial

Where to use 0:05:52

Where to use Regular Expressions in Google Analytics?

Using regular expressions 0:10:53

Using regular expressions in GA4 || RegEx in GA4

A Marketer’s Guide 0:19:25

A Marketer’s Guide to Using Regex in the Search Console

Learn to use 0:10:02

Learn to use RegEx in Google Sheets in 10 minutes

What is Regex 0:04:40

What is Regex and a little history

Regular Expressions for 0:19:27

Regular Expressions for Google Sheets | Spreadsheets for Automation in Motion Design

How to use 0:14:51

How to use the Data Studio Case Function

Regular Expressions 101 0:30:47

Regular Expressions 101

Regex in Google 0:00:30

Regex in Google Sheets

Regular Expression (RegEx) 0:18:45

Regular Expression (RegEx) in Google Analytics

BigQuery Regular Expression 0:23:22

BigQuery Regular Expression | REGEXP_CONTAIN, EXTRACT, REPLACE

Комментарии
Автор

Hi, Excellent explanation, how can I do the same but for numerical values? For example:
REGEXP_REPLACE (Average Position, 'Range 1.6 to 2.5', 'replace by number 2')

gloriaitziriosunaarellano
Автор

Hola, tal vez me equivoco pero no eres tu quien enseña el curso de Data Studio en PLATZI?

Espero me puedas ayudar con una consulta que no he podido resolver.

Tengo una columna con nombres de distintas personas, en este caso suelen ser max 3 por celda separados por coma ", "
El asunto es que quiero mostrar solo el primer nombre en una tabla, sin que aparezcan los demás para así poder hacer un top.

¿tendrás alguna sugerencia? :, D

DanielHernandez-tofj
Автор

How do you remove characters? Like if the text is "aaa-bb", I want to extract "aaa" only, or similarly remove "-bb"

javidtaghiyev
Автор

How to remove "other" so that would leave only youtube and google????

rafabaszczyk
Автор

It works until I remove the first dimension, and it goes bust giving me an error message. Any idea on that?

yacinelhichri
Автор

Nice man. However, how can I find something in a text? Like when I have something in multiple lines?

ruinogueira