+ Reply to Thread
Results 1 to 4 of 4

Need help extracting values from variable length results

  1. #1
    Registered User
    Join Date
    01-29-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    2

    Need help extracting values from variable length results

    Hi everyone,

    This is my first post, so I appreciate any help anyone can offer. I've been looking for a solution to this issue for a few hours today and have not been able to find anything workable.

    The attached worksheet has a sample download of search queries made to my company's website. Due to the way search was built, I cannot get more customized results at this time. What I'm trying to do is extract the search criteria entered from each term. Here is a somewhat typical result, placed in the attached spreasheet in B2:

    type=lease,isLocation=true,locations=All location,PriceSlider_MinValue=10K,PriceSlider_MaxValue=200K ,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=Centerstage ,totalResult=0

    The extracted values would hopefully be:
    C2 - Lease
    D2 - All location
    E2 - 10K
    F2 - 200K
    ...
    And so on. My problem is that locations and keyword are both variable and unpredictable lengths, and several other results are variable but predictable lengths, so I am having trouble locating the desired values for copying into the cells. I'm hoping to find a formula that can grab the values I'm looking for, as my VBA skills are virtually non-existent and I want to be able to tweak if necessary.

    Any help or ideas would be greatly appreciated.

    Thanks.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Need help extracting values from variable length results

    try this function
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    look attachment i've done 4 columns..same logical approach using mid
    extract words/text between two string specified.

    Analytics Search Terms 20130129-20130129 (1).xlsx
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    01-29-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need help extracting values from variable length results

    I think this may have done it. Thank you SO much for your help.

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Need help extracting values from variable length results

    Your welcome.

    regards,
    vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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