I'm struggling with extracting from URL only country for example .pl
from https://www.google.pl
.
At this moment I'm able to extract google.pl
from provided url using the following code:
TRIM(REGEXP_EXTRACT(REGEXP_REPLACE(REGEXP_REPLACE(URL, "https?://", ""), R"^(w{3}\.)?", ""), "([^/?]+)"))
What is needed to change in this code to provide only .pl
instead of example.pl
?
Thanks in advance.
You can use
REGEXP_EXTRACT(URL, r'https?://[^/]*\.([^/]+)')
See the regex demo. Details:
https?://
- https://
or http://
[^/]*
- zero or more chars other than /
\.
- a .
char([^/]+)
- Group 1: one or more chars other than /
.