Spreadsheet: 215033d1361231399-need-help-extracting-values-from-variable-length-results-analytics-search-terms-20130129-20130129-1-
Sheet: Dataset1

 | Search Term | Type | Locations | Min Price | [NAME] | Min [NAME] | [NAME] | Min Bed | [NAME] | Min Bath | [NAME] | Features | Keywords | Results
1 | 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
2 | 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=Centrestage,totalResult=16
3 | 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=[NAME],totalResult=11
4 | 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=[NAME] terrace,totalResult=9
5 | type=lease,isLocation=true,locations=All location,PriceSlider_MinValue=13K,PriceSlider_MaxValue=35K,SizeSlider_MinValue=800,SizeSlider_MaxValue=1600,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=209
6 | type=lease,isLocation=true,locations=All location,PriceSlider_MinValue=18K,PriceSlider_MaxValue=35K,SizeSlider_MinValue=700,SizeSlider_MaxValue=1500,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=304
7 | type=lease,isLocation=true,locations=Area,PriceSlider_MinValue=80K,PriceSlider_MaxValue=90K,SizeSlider_MinValue=1700,SizeSlider_MaxValue=3500,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=3,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=4,isFeature=false,[NAME]
8 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=80K,PriceSlider_MaxValue=150K,SizeSlider_MinValue=1700,SizeSlider_MaxValue=3500,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=3,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=4,isFeature=false,keyWord=,totalResult=152
9 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=50K,PriceSlider_MaxValue=100K,SizeSlider_MinValue=1700,SizeSlider_MaxValue=3500,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=3,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=4,isFeature=false,keyWord=,totalResult=154
10 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=60K,PriceSlider_MaxValue=100K,SizeSlider_MinValue=1700,SizeSlider_MaxValue=3000,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=3,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=4,isFeature=false,keyWord=,totalResult=143
11 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=50K,PriceSlider_MaxValue=100K,SizeSlider_MinValue=1700,SizeSlider_MaxValue=3000,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=3,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=4,isFeature=false,keyWord=,totalResult=152
12 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=80K,PriceSlider_MaxValue=90K,SizeSlider_MinValue=1700,SizeSlider_MaxValue=3500,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=3,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=4,isFeature=false,keyWord=,totalResult=38
13 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=80K,PriceSlider_MaxValue=100K,SizeSlider_MinValue=1700,SizeSlider_MaxValue=3500,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=3,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=4,isFeature=false,keyWord=,totalResult=71
14 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=10K,PriceSlider_MaxValue=25K,SizeSlider_MinValue=500,SizeSlider_MaxValue=2000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=2,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=2,isFeature=false,[NAME]
15 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=10K,PriceSlider_MaxValue=25K,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=2,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=2,isFeature=false,[NAME]
16 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=10K,PriceSlider_MaxValue=25K,SizeSlider_MinValue=700,SizeSlider_MaxValue=2000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=2,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=2,isFeature=false,keyWord=,totalResult=24
17 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=35K,PriceSlider_MaxValue=60K,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=133
18 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=40K,PriceSlider_MaxValue=60K,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,[NAME]
19 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=35K,PriceSlider_MaxValue=60K,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=103
20 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=35K,PriceSlider_MaxValue=50K,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=52
21 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=10K,PriceSlider_MaxValue=25K,SizeSlider_MinValue=700,SizeSlider_MaxValue=2000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=2,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=2,isFeature=false,keyWord=,totalResult=3
22 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=35K,PriceSlider_MaxValue=50K,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,[NAME]
23 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=35K,PriceSlider_MaxValue=50K,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=2
24 | type=lease,isLocation=true,locations=Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=35K,PriceSlider_MaxValue=50K,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,[NAME]
25 | type=lease,isLocation=true,locations=Hong Kong Island,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=,totalResult=94
26 | type=lease,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=20K,PriceSlider_MaxValue=30K,SizeSlider_MinValue=600,SizeSlider_MaxValue=1100,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=8
27 | type=lease,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=20K,PriceSlider_MaxValue=40K,SizeSlider_MinValue=600,SizeSlider_MaxValue=1100,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=16
28 | type=lease,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=20K,PriceSlider_MaxValue=60K,SizeSlider_MinValue=600,SizeSlider_MaxValue=1600,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=25
29 | type=lease,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=50K,PriceSlider_MaxValue=100K,SizeSlider_MinValue=1700,SizeSlider_MaxValue=3000,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=19
30 | type=lease,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=50K,PriceSlider_MaxValue=100K,SizeSlider_MinValue=1700,SizeSlider_MaxValue=3000,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=5,isFeature=false,keyWord=le mer,totalResult=0
31 | type=lease,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=60K,PriceSlider_MaxValue=100K,SizeSlider_MinValue=1700,SizeSlider_MaxValue=3000,BedroomSlider_MinValue=2,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=17
32 | type=lease,isLocation=true,locations=New Territories,New Territories,New Territories,New Territories,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=,totalResult=18
33 | type=sale,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=aqua,totalResult=4
34 | type=sale,isLocation=true,locations=All location,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=Centerstage ,totalResult=0
35 | type=sale,isLocation=true,locations=All location,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=mer,totalResult=35
36 | type=sale,isLocation=true,locations=All location,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=westminster,totalResult=0
37 | type=sale,isLocation=true,locations=Hong Kong Island,Hong Kong Island,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,[NAME]
38 | type=sale,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=16M,PriceSlider_MaxValue=40M,SizeSlider_MinValue=1600,SizeSlider_MaxValue=3000,BedroomSlider_MinValue=3,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=2,BathroomSlider_MaxValue=5,isFeature=false,keyWord=residence bel air,totalResult=0
39 | type=sale,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=16M,PriceSlider_MaxValue=40M,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=residence bel air,totalResult=0
40 | type=sale,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=1100,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=114
41 | type=sale,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=1100,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=4
42 | type=sale,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=1400,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=52
43 | type=sale,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=10
44 | type=sale,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=137
45 | type=sale,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=257
46 | type=sale,isLocation=true,locations=Hong Kong Island,PriceSlider_MinValue=4M,PriceSlider_MaxValue=250M ,SizeSlider_MinValue=500,SizeSlider_MaxValue=5000,BedroomSlider_MinValue=0,BedroomSlider_MaxValue=10,BathroomSlider_MinValue=1,BathroomSlider_MaxValue=5,isFeature=false,keyWord=,totalResult=78