Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Remove root domain from URL

Topic Labels: Formulas
756 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lauren_VIlla
4 - Data Explorer
4 - Data Explorer

I want to remove the root domain from all of my URLs after a specific character. I want to remove the root of our URL (https://cotoncolorscompanywholesale.com) AND I want to remove /pages/ so that I am only left with the actual page name. 

Take these two URL's as an example: 

https://cotoncolorscompanywholesale.com/pages/faq     

https://cotoncolorscompanywholesale.com/pages/for-poppy-campaign   

I want them to be trimmed to read as: 

faq 

for-poppy-campaign 

Can you help me with this?

1 Reply 1
Sho
11 - Venus
11 - Venus

For example, with REGEX, it looks like this

REGEX_EXTRACT({URL},"//.*/(.*)")