Remove everything to the right of a character
Hi, I've searched the forum, but can't seem to find a solution.
I have a series of domain names all different length. Some of them have subdomains, some don't. I need to automatically remove the subdomain text.
Domain 1: thisisadomain.com/ = no issue
Domain 2: thisisanewdomain.com/en = I want to remove everything to the right of the /
Domain 3: thisisanotherdomain.com/products/en = I want to remove everything to the right of the first /
I should just end up with:
The issue is the different lengths of the domains before the / appears.
I have it in my head that I should use FIND to find the first / and then replace anything after that with "", but I don't know if that's the right way of thinking - if it is, I can't get it to work! Any help greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!