Get Information

[121278]

Hi,

i have a table column with information about a users browser and operating system,
like
mozilla,internet explorer6,win98,en,....

how can i analyse parts of the content e.g how many win98 users there are with this info?

i tried to extract the info in asp
(so i made a recordset with "append" win98; ie6 ,...)
but it has extremely low performance

can i extract it in crystal and make charts with info stored in a string?
or do i need to get all info in this string into seperate columns in the database to increase performance?

greetings
chris

 

[IdoMillet]

Assuming your string column is {software}
you can create a formula of:

IF "win98" in {software} THEN 1 ELSE 0

Then sum that formula to get your count.

You could do the same with a Running Total.

Cheers,
- Ido ixm7@psu.edu