Extracting Part of a URL

Question

I am looking to only extract part of the URL. It will always be the two sections after the .co.uk/

For example

https://websiteaddress.co.uk/extract this/andthis/gclid=CjwKCAjw7--KBhAMEiwAxfpkWMKrv223JAuniVdiwizN0ME3cN4RbCQSY8dT-wqBW

From the above URL I want to extract 'extract this/andthis' the text will differ however it will always be the two sections straight after the .co.uk

I have played around with RegEx and REGEX_Replace but to no luck

Thankyou

atcodedog05 · Accepted Answer

Hi @tf05

Here is how you can do it. I am assuming the last part always = (I,e Is a part which is passing parameter)

Workflow:

Hope this helps : )

binu_acs · Accepted Answer

@tf05

REGEX_Replace([URL], '(.*)\/.+', '$1')