Help

Remove root domain from URL

Topic Labels: Formulas
186 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},"//.*/(.*)")