Extracting Part of a URL

[tf05]

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 solution]

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 : )

[binuacs · Accepted solution]

@tf05 

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

[atcodedog05]

Happy to help : ) @tf05 

Cheers and have a nice day!

[reignM]

You too! Thank you for the https://regex101.com/ sandbox link. That would definitely help with my learning on RegEx tremendously. Have a wonderful day ahead :)