Remove String out of URL

[lbolin]

i have several Url that have /about/ on the end of them that i am needing to remove. I have tried Contains([url],"\about\","") but it turns all the urls 

URL Examples:

https://www.linkedin.com/company/cdm-vertical-llc/about/
https://www.linkedin.com/company/syncorp/about/
https://www.linkedin.com/company/kimberlina-whettam-&-associates-inc/about/
https://www.linkedin.com/company/cosine-collective/about/
https://www.linkedin.com/company/evan-brooks-associates/about/
https://www.linkedin.com/company/advanced-data-storage/about/
https://www.linkedin.com/company/peak-performance-seminars-&-consulting/about/
https://www.linkedin.com/company/the-garrettspioni-group/about/
https://www.linkedin.com/company/the-whitewater-group/about/
https://www.linkedin.com/company/ybmarketing/about/

I want to join these with other urls to find overlap/the same  urls.

[patrick_digan]

@lbolin You can use replace to remove parts of a string 

replace([url],"/about/","")

You'll want to double check which direction your slashes are going. 

[Tyro_abc]

I tried this formula, seems to be working

TrimRight([URL],'/about/')

Regards

Arundhuti

[Qiu]

@lbolin 

In your formula, its Contains([url],"\about\","") , its backslash, you should use slash "/"