Help

Removing the tail end from URLs

Topic Labels: Formulas
Solved
Jump to Solution
3630 10
cancel
Showing results for 
Search instead for 
Did you mean: 
John_Krueger1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey AT Community!

Is there a way to remove the tail ends from formulas in bulk?

Example-

I have 3 urls in 3 different rows:

https://google.com/index?test
https://yahoo.com/example?test
https://apple.com/ending?test

Using a formula (or something else) I’d like to get rid of the tails so that I am left with:

https://google.com/
https://yahoo.com/
https://apple.com/

I feel like this should be possible?

Appreciate any pointers!

10 Replies 10

It doesn’t have to be the actual data, but should represent the universe of possible patterns.