Beast mode for the substring_index

Atieh · 2024-05-27T19:46:12+00:00

There was an error rendering this rich post.

I'm trying to extract the substring from an URL.

URL: www.ab.com/level1/level2

I'm looking taking the level2 out of URL. What is the beast mode formula I can use here?

I want to get: level2

Find more posts tagged with

Beast Mode

you can use SPLIT_PART (Beast Mode or Magic ETL formula tile) or REGEXP_REPLACE (Magic ETL formula tile only)

SPLIT_PART(`url`, '/', 3)

REGEXP_REPLACE(`url`, '^(http://)?([^/]+/){2}([^/]+).*$', '$3')

you can use SPLIT_PART (Beast Mode or Magic ETL formula tile) or REGEXP_REPLACE (Magic ETL formula tile only)

SPLIT_PART(`url`, '/', 3)

REGEXP_REPLACE(`url`, '^(http://)?([^/]+/){2}([^/]+).*$', '$3')

Thanks so much! It worked