i need the formula that can go backward one or two directory in url link, so the result would be:
i read article about relative file paths: Starting with "/" returns to the root directory Starting with "../" moves one directory backwards Starting with "../../" moves two directories backwards
How to do that on google sheets formula or script, assume i have in A1: https://www.mybookstore.com/images/products/80/1020/40422/2/279/howtocookegg8.jpg
so column B1: would be https://www.mybookstore.com/images/products/80/1020/40422/2/howtocookegg8.jpg
i need formula or script that can do that, please help, thanks you.