Extract relative path from URL

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?

Ok, I found the way.

=RIGHT(Column 1,LEN(Column 1)-FIND("/",Column 1,FIND("//",Column 1)+2)+1)

1 Like

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.