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.
Bookmarks