Help

Need help doing a Lookup with a calculated string

860 0
cancel
Showing results for 
Search instead for 
Did you mean: 
mtrifiro
5 - Automation Enthusiast
5 - Automation Enthusiast

I use a formula to extract the base domain from a long URL
e.g.,

LEFT(Link,FIND("/",Link,4+FIND("://",Link)))

which will take something like:

'https://www.networkworld.com/article/3202753/data-center/data-center-startup-offers-compute-colo-at-...

and return the base domain:

'https://www.networkworld.com/

I then want to use that base domain to do a lookup into a table that maps the domain to an actual human readable title of the site, but the Lookup won’t let me use the extracted URL. The formula field where the string manipulation occurs is not offered as one of the options for Lookup.

Help!

0 Replies 0