Results 1 to 3 of 3

Search within a string and return data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-10-2007
    MS-Off Ver
    Excel 2010
    Posts
    293

    Search within a string and return data

    Hello,

    I am wanting to search from within a string, search only when:

    filter=(a_brand_t_fq:"BrandLoonry")

    and return what's in the quote. so whenever you see: "filter=(a_brand_t_fq:" return the value in quotes so it should return, BrandLoonry

    Original:

    https://www.abc123.com/search?breadcrumbs%5B0%5D=red-big-widget&breadcrumbs%5B1%5D=red-long-big-widgets&cc=LUNERATOOBS&facet.multiselect=true&page=1&q=*&rows=15&son=0&sort=price+asc&start=0&filter=(category:"12897")&filter=(a_brand_t_fq:"BrandLoonry")&filter=(a_length_d_fq:[12%20TO%2024]%20OR%20a_length_d_fq:[24%20TO%2036]%20OR%20a_length_d_fq:[36%20TO%2048])&filter=(a_dimmable_t_fq:"Yes")'),

    Desired: result.

    BrandLoonry

    See spreadsheet for actual data on 1st tab and desired result on 2nd tab.

    thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search for string in a 2d array and return string
    By david0985 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2016, 04:59 AM
  2. Script to Search for a specific String then return cell values above that String-4
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2015, 01:28 AM
  3. [SOLVED] Script to Search for a specific String then return cell values above that String-3
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2015, 01:50 PM
  4. [SOLVED] Script to Search for a specific String then return cell values above that String-2
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2015, 01:00 PM
  5. [SOLVED] Script to Search for a specific String then return cell values above that String
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2015, 11:28 AM
  6. Search column for string and return every row with that string in new sheet
    By myers601 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2012, 06:02 PM
  7. Replies: 2
    Last Post: 02-26-2008, 03:22 PM

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