URL Coding

[Steve95]

Hi All

Iam doin web reporting and need help with a formula, the log records are as follows: -

mba.nsf/web/home + page/100/1
home.nsf/web/home + page/101/1
mba.nsf/web/programme + page/100/2

The report is grouped by "mba" or "home" etc, the "100" in the url represents a unique cookie id and the number followed represents how many pages they have viewed so far.

What I need is a formula which reads through the log and brings back rows which have the same unique cookie id.

Please can you help.

Many Thanks

 

[dgillz]

Will the cookie ID always be in between the last 2 slash marks?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[dgillz]

The following formula will return everything in between the last 2 slash marks:

mid(left({yourfield},instrrev({yourfield},"/")-1),instrrev(left({yourfield},instrrev({yourfield},"/")-1),"/")+1)

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Steve95]

Hi dgillz

thanks for your response, I can extract the cookie id, what I need is to see if the next record has the same cookie id and if so to show both.

Please feel free to ask further information.....

Many Thanks

 

[Steve95]

Just to add to the above I have tried using previous and next and just this formula works to a certain extent but falls when it comes to the last record.

 

[lbass]

Insert a second group on Don's formula. If you only want to show those unique codes where there is more than one record, then go to report->selection formula->GROUP and enter:

count({table.field},{@dgillzformula}) > 1

//where {table.field} is any recurring (non-null) field.

-LB

 

[dgillz]

If you do not want to see duplicates only, but want to see all records, just change your formula using the next() function to start as follows:

Not OnLastRecord;

This will stop the error. Similarly, if you are using the previous() function, the first record will error unless you start off with:

Not OnFirstRecord;

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz