lucy24 - 7:47 am on Dec 13, 2011 (gmt 0)

Hey engine. Sure, but that's not quite what I'm getting at. I end up with a column of referrers, e.g.: - www.google.com/search?q=keyword1+keyword2 - search.yahoo.com/search?p=keyword3+keyword4+keyword5 - www.bing.com/search?q=keyword6, etc.

Holy ###. How did you manage to screen out all the accompanying garbage that's wrapped around your ordinary search-engine referer? It's taken me months and I still have to weed out the occasional false positive-- or delve into raw logs to find something essential that got deleted because it disguised itself as something I'm not interested in.

At this point, all you need is a RegEx search for \?(q\w*|text) and maybe a couple of others depending on which search engines you get. Replace that with a column break according to whatever database format you're using. And while you're at it, change the \+ back into the space that it started out as.

But don't get too optimistic about that "keyword1 keyword2 keyword3" business. It's just as likely to be "how can I keyword3 on my keyword2 when I need to keyword1 but I don't have a keyword4?" or "irrelevant1 irrelevant2 keyword irrelevant3".