Remove String out of URL
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried this formula, seems to be working
TrimRight([URL],'/about/')
Regards
Arundhuti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In your formula, its Contains([url],"\about\","") , its backslash, you should use slash "/"
