Help

Re: Extract relative path from URL

505 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jia_Pei_Wong
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Reply 1
Jia_Pei_Wong
5 - Automation Enthusiast
5 - Automation Enthusiast

Ok, I found the way.

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