Extract part URL up to 2nd sub directory or file path

[SKooLZ]

Hi all, I have a list of SharePoint file URLs and I need you help with a formula to extract part of the URL up to the 2nd sub directory or sub-site e.g.

http://company.sharepoint.com/teamsite/Subdirectory1/
http://company.sharepoint.com/teamsite/Subdirectory1/folderA/folder1/
http://company.sharepoint.com/teamsite/Subdirectory1/folderB/
http://company.sharepoint.com/teamsite/Subdirectory2/
http://company.sharepoint.com/teamsite/Subdirectory2/folderC/
http://company.sharepoint.com/teamsite/Subdirectory3/
http://company.sharepoint.com/teamsite/Subdirectory3/folderD/
http://company.sharepoint.com/teamsite/Subdirectory3/folderE/folder2

The expected result I'm after on the right or left of a corresponding column to the above list, would be:

http://company.sharepoint.com/teamsite/Subdirectory1/
http://company.sharepoint.com/teamsite/Subdirectory1/
http://company.sharepoint.com/teamsite/Subdirectory1/
http://company.sharepoint.com/teamsite/Subdirectory2/
http://company.sharepoint.com/teamsite/Subdirectory2/
http://company.sharepoint.com/teamsite/Subdirectory3/
http://company.sharepoint.com/teamsite/Subdirectory3/
http://company.sharepoint.com/teamsite/Subdirectory3/


Caputuring just the first 2 sub directories which are: teamsite/subdirectoryX/

thanks in advance

 

[SKooLZ]

I didn't realise they were the same site... Note taken for next time as I didn't realise I could post links other forum. Thanks!

 

[jtakw]

These are Not the Same site, every forum has their rules, I'm also a member on the other one you posted at.
As you see, the rule for Cross-Posting is A Lot stricter there than here, your other thread got "frozen" by MOD until corrected, where this one is still open to discussion.