Removing the tail end from URLs

[John_Krueger1]

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!

[Bill_French]

John_Krueger1:

The data is confidential at this point so I’m unable to share it in bulk.

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