My dataset features many variations of URLs such as:
somewebsite.com/en-us/city/amelia-island
somewebsite.com/en-us/city/anna-maria-island
somewebsite.com/en-us/city/boca-grande
and
somewebsite.com/en-us/listing/lake-buena-vista
somewebsite.com/en-us/listing/lake-placid
somewebsite.com/en-us/listing/lakeland
and
somewebsite.com/golf/listing/fort-pierce
somewebsite.com/golf/listing/fort-walton-beach
somewebsite.com/golf/listing/miami
I need to map to a field called SITE, for example:
somewebsite.com/golf/listing/fort-pierce = GOLF CITY
somewebsite.com/golf/listing/fort-walton-beach = GOLF CITY
somewebsite.com/en-us/listing/lake-buena-vista = CITY LISTING
somewebsite.com/en-us/listing/lake-placid = CITY LISTING
somewebsite.com/en-us/city/anna-maria-island = CITY DETAIL
somewebsite.com/en-us/city/boca-grande = CITY DETAIL
So in the TABLE ARRAY, I put
somewebsite.com/golf/listing/* = GOLF CITY
somewebsite.com/en-us/listing/* = CITY LISTING
somewebsite.com/en-us/city/* = CITY DETAIL
Hoping that a LOOKUP would understand that it should return the SITE. But it doesn't work.
I spent a couple of hours searching support sites like this one, but cannot find an example that is similar enough to be useful to me.
I'm hoping some kind soul here will help.
Thank you in advance!
Bookmarks