Question

How would I be able to extract data from WebStatistics (only the 'Topic Views' section of the table) using a regex in TWiki?

Environment

-- VivekDelhikar - 18 Feb 2004

Answer

Ok... I've figured it out, the regex would look like:

%INCLUDE{"%STATISTICSTOPIC%" pattern=".*?\-\-statTopContributors\-\-\>[^\|]+\|[^\|]+\|[^\|]+\|[^\|]+\|[^\|]+\|[^\|]+(\|[^\|]+\|[^\|]+\|).*"}%

However, how would I be able to exclude topics such as WebHome using the regex I've got above?

-- VivekDelhikar - 19 Feb 2004

Write this to get the all topics:

%INCLUDE{"%STATISTICSTOPIC%" pattern=".*?\-\-statTopContributors\-\-\>[^\r\n]+[\r\n]+\|[^\|]+\|[^\|]+\|[^\|]+\|[^\|]+([^\r\n]+).*"}%

This renders as:

You can skip anything up to and including WebHome. Notice that this regex is kind of flaky, it assumes that the WebHome topic is there and that anything more popular is noise:

|%INCLUDE{"%STATISTICSTOPIC%" pattern=".*?\-\-statTopContributors\-\-\>[^\r\n]+[\r\n]+.*?WebHome[^0-9]*([^\r\n]+).*"}%

This renders as:

-- PeterThoeny - 05 May 2004