+ Reply to Thread
Results 1 to 7 of 7

Table Array with Wildcard involving partial URL match

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    Charlotte, NC
    MS-Off Ver
    for Mac 2011
    Posts
    4

    Table Array with Wildcard involving partial URL match

    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!

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Table Array with Wildcard involving partial URL match

    Hi,

    an attempt to extract the sites from strings



    Please Login or Register  to view this content.
    Regards
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    10-29-2014
    Location
    Charlotte, NC
    MS-Off Ver
    for Mac 2011
    Posts
    4

    Re: Table Array with Wildcard involving partial URL match

    Thanks but this can't be right? I need a LOOKUP or INDEX/MATCH.

  4. #4
    Registered User
    Join Date
    10-29-2014
    Location
    Charlotte, NC
    MS-Off Ver
    for Mac 2011
    Posts
    4

    Re: Table Array with Wildcard involving partial URL match

    Uploaded a spreadsheet with dataset and in-process mapping.

    On the MAPPING tab, I used red to highlight where I need wildcard matching.

    For Excel Forum.xlsx

  5. #5
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Table Array with Wildcard involving partial URL match

    Sorry I've totally misunderstood your problem

    Cheers

  6. #6
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Table Array with Wildcard involving partial URL match

    Hi,

    while we are waiting for some good help from Forum Experts, please see if formula like


    Please Login or Register  to view this content.
    could be of some help.


    Just for sharing some ideas.

    Cheers
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    10-29-2014
    Location
    Charlotte, NC
    MS-Off Ver
    for Mac 2011
    Posts
    4

    Re: Table Array with Wildcard involving partial URL match

    My bad! It seems my original post was not complete enough. Thank you for trying!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Trying to match partial string to an array, need to output related cell
    By vijaijohn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-23-2013, 03:04 PM
  2. [SOLVED] Partial Match Cell To String Array
    By amazinglazers in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2013, 05:56 AM
  3. vlookup table array wildcard?
    By liquidskin in forum Excel General
    Replies: 5
    Last Post: 03-27-2009, 09:52 AM
  4. Partial Match in an Array
    By matrex in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-13-2008, 09:40 PM
  5. [SOLVED] Reference worksheet by partial name ?? wildcard
    By Dale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2006, 07:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1