I would like to create a formula that could extract relative path from a full URL.
Example:
Column 1
domain1/landing-url-1
domain2/landing-url-2
domain3/landing-url-3
domain4/landing-url-4
Relative path:
/landing-url-1
/landing-url-2
/landing-url-3
/landing-url-4
TRIM(MID({Column 1},SEARCH(“domain1”,{Column 1})+LEN(“domain1”),255))
I managed to create the formula that could extract from a particular domain, but I have 4 different types of domain in column 1. How can I combine them into one?