How to extract a substring from an URL

qzqzqzqzqz

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

Input: www.abcd.com/level1/level2

The output I'm looking for is essentially taking from the first character to the position of the second '/' minus 1. I wonder how to write the formula in beast mode.

Desired output: www.abcd.com/level

GrantSmith

CONCAT(SPLIT_PART(`url`, '/', 1), '/', SPLIT_PART(`url`, '/', 2))

SPLIT_PART will get the values with the data split out by a specific character. It's undocumented in the UI but is accessible.

Concat then takes those two values and combines them together with the / inbetween

david_cunningham

SUBSTRING_INDEX(url,'/',2)

GrantSmith

CONCAT(SPLIT_PART(`url`, '/', 1), '/', SPLIT_PART(`url`, '/', 2))

SPLIT_PART will get the values with the data split out by a specific character. It's undocumented in the UI but is accessible.

Concat then takes those two values and combines them together with the / inbetween

david_cunningham

SUBSTRING_INDEX(url,'/',2)

qzqzqzqzqz

thank you both! unfortunately my beastmode has neither substring_index or split_part. is there a reason I don't see the functions

qzqzqzqzqz

Actual both worked although the functions do not show up in Beast Mode. thank you both!!!

GrantSmith

There's several functions which aren't listed in the function list but do still exist. Hopefully Domo gets it updated.