Extract Domain Name from URL using Google RE2 Regexp for Data Studio

Question

I have a list of URLs in an event action field, and need to extract only the domain name (without TLD) using Data studio:

https://example.com => example
https://www.example.com => example
https://subdomain.example.com => example

Managed to extract everything but the non www version with this:

REGEXP_EXTRACT(Event Action, '^[^.]+.([^.]+)')

Any ideas how extract the non www version as well? Appreciate any help.

Nimantha · Accepted Answer · 2020-02-17 09:17:29Z

2

This does the trick (Created a Google Data Studio Report (Google Sheets Embedded) to demonstrate):

REGEXP_EXTRACT(Event Action, "(\\w+)\\.\\w+$")

answered Feb 17, 2020 at 9:17

Nimantha

6,5476 gold badges32 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1