importing log file into excel

[kenny]

When more than one category is selected in the search form, using a comma as the delimiter to import the log file into excel it creates extra columns.

The extra commas after Cat = on the 2nd line below is what I am talking about.

Is there a way to import the log file into excel correctly when more than one category is selected?

2011-11-10, 16:03:10, 218.253.108.226, "voip", Matches = 0, AND, PerPage = 10, PageNum = 0, "Cat = All", Time = 0.010, Rec = 0
2011-11-10, 16:17:56, 218.253.108.226, "ims", Matches = 124, AND, PerPage = 10, PageNum = 0, "Cat = Report Highlights, Events, White Papers", Time = 0.013, Rec = 0

[David]

Hmmm. Looks like a bug that we'll need to fix.

In the meantime as a work around load up the file into a text editor and do a global search and replace.

Search for,

s,

and replace with

s;

[kenny]

thanks.
this will work for now.
we would like to link the zoom log file to a script so we can look up the geo location to show where the searches are coming from around the world, so omitting a step to fix the log file will be helpful.

if anyone is interested maxmind.com offers a free database file that you can download to look up the IP geo info.

[Ray]

From the next alpha release of V7 onwards, the category string will be delimited by semi-colons to address this issue with Excel.

That is, it will look like:
"Cat = Report Highlights; Events"

Of course, existing log files and previous log entries from releases before will still be delimited by commas.