The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

Need help doing a Lookup with a calculated string

posted Jul 9, 2018 7:28:33 AM

0 1090 0

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