Trimming Folder Path of a Url Without Losing First Folder In Google Sheets

In Google Sheets: I would like to trim a list of urls to first folder

for example:

url.com/folder1/xxx/index.html    url.com/folder2/    url.com/folder3/xxx/yyyy/index.html    url.com/folder4/zzz/aaa/bbb/index.html  

Output should look like this:

url.com/folder1/    url.com/folder2/    url.com/folder3/    url.com/folder4/  

I need to find a formula I can use in Google Sheets, which easily takes care of this all at once for at least 10,000 urls?

I found this tool https://regex101.com/r/aS7zX3/3 However, it does not work when you enter more than 1000 urls.

Any help would be much appreciated. Thanks!

https://stackoverflow.com/questions/66727381/trimming-folder-path-of-a-url-without-losing-first-folder-in-google-sheets March 21, 2021 at 07:16AM