Remove root domain from URL

[Lauren_VIlla]

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?

[Sho]

For example, with REGEX, it looks like this

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