Parsing Question

Post Reply
gerry.odea
Posts: 98
Joined: Fri Sep 19, 2008 9:33 am

Parsing Question

Post by gerry.odea »

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.
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Parsing Question

Post by mark »

Maybe
/>>query":"\P=[^"]*\F","language":"
gerry.odea
Posts: 98
Joined: Fri Sep 19, 2008 9:33 am

Parsing Question

Post by gerry.odea »

<$imports=
'recdelim >><item
multiple
field Title varchar />><a=[^>]*>\P=!</a>+ ""


Had a mental block. Nevermind I got it working. Thanks
Post Reply