I'm trying to parse something that looks like this:
field Cache varchar(40) />>\query":"\P\","language":"
The raw data looks like this:
nowqueries = {"queries":[{"query":"reggie bush injury","language":"en","country":"us","type":3,"search_link":"http://www.google.com/search?q=reggie%2 ... "photoshop elements 9","language":"en","country":"us","type":3,"search_link":"http://www.google.com/search?q=photosho ... uery":"how old is david hasselhoff","language":"en","country":"us","type":3,"search_link":"http://www.google.com/search?q=how%20ol ... ry":"bruno mars","language":"en","country":"us","type":3,"search_link":"http://www.google.com/search?q=bruno%20 ... ":"dancing with the stars season 11","language":"en","country":"us","type":3,"search_link":"http://www.google.com/search?q=dancing% ... y":"ingrid betancourt","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=ingrid%2 ... helicopter crash","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=helicopt ... ry":"japan china","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=japan%20 ... ry":"david hasselhoff","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=david%20 ... y":"lasker award","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=lasker%2 ... mmonwealth games delhi","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=commonwe ... ery":"rick fox eliza dushku","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=rick%20f ... uery":"nfl player dead","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=nfl%20pl ... ry":"teeth whitening","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=teeth%20 ... uery":"nfl player found dead","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=nfl%20pl ... _source":0}],"timestamp":"1285046566","locale":"en-us"};
it's on one line and I'm having a very hard time trying to parse it to pull out:
reggie bush injury
photoshop elements 9
how old is david hasselhoff
bruno mars
broncos
dancing with the stars season 11
bermuda
ingrid betancourt
helicopter crash
saints
etc...
Please help me. I'm really stuck trying to figure it out.
field Cache varchar(40) />>\query":"\P\","language":"
The raw data looks like this:
nowqueries = {"queries":[{"query":"reggie bush injury","language":"en","country":"us","type":3,"search_link":"http://www.google.com/search?q=reggie%2 ... "photoshop elements 9","language":"en","country":"us","type":3,"search_link":"http://www.google.com/search?q=photosho ... uery":"how old is david hasselhoff","language":"en","country":"us","type":3,"search_link":"http://www.google.com/search?q=how%20ol ... ry":"bruno mars","language":"en","country":"us","type":3,"search_link":"http://www.google.com/search?q=bruno%20 ... ":"dancing with the stars season 11","language":"en","country":"us","type":3,"search_link":"http://www.google.com/search?q=dancing% ... y":"ingrid betancourt","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=ingrid%2 ... helicopter crash","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=helicopt ... ry":"japan china","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=japan%20 ... ry":"david hasselhoff","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=david%20 ... y":"lasker award","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=lasker%2 ... mmonwealth games delhi","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=commonwe ... ery":"rick fox eliza dushku","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=rick%20f ... uery":"nfl player dead","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=nfl%20pl ... ry":"teeth whitening","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=teeth%20 ... uery":"nfl player found dead","language":"en","country":"us","type":6,"search_link":"http://www.google.com/search?q=nfl%20pl ... _source":0}],"timestamp":"1285046566","locale":"en-us"};
it's on one line and I'm having a very hard time trying to parse it to pull out:
reggie bush injury
photoshop elements 9
how old is david hasselhoff
bruno mars
broncos
dancing with the stars season 11
bermuda
ingrid betancourt
helicopter crash
saints
etc...
Please help me. I'm really stuck trying to figure it out.