Skip to content

Instantly share code, notes, and snippets.

@alecbw

alecbw/url_split.sql

Created January 11, 2023 17:46
Show Gist options
  • Save alecbw/c34ab9369fdcbf012c34666a8deea42b to your computer and use it in GitHub Desktop.
Save alecbw/c34ab9369fdcbf012c34666a8deea42b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. alecbw created this gist Jan 11, 2023.
    11 changes: 11 additions & 0 deletions url_split.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,11 @@
    WITH sample_data AS (
    SELECT 'https://www.example.com' AS url
    )
    SELECT
    CASE
    WHEN split_part(split_part(url, '://', 1), 'www.', 1) = url THEN url
    WHEN split_part(url, '://', 1) = url and split_part(url, 'www.', 1) != url THEN split_part(url, 'www.', 2)
    WHEN split_part(url, '://', 1) != url and split_part(url, 'www.', 1) = url THEN split_part(url, '://', 2)
    ELSE split_part(split_part(url, '://', 2), 'www.', 2)
    END as result
    FROM sample_data