Is there any way the Ceton giveaway thread can be parsed.

[PAPutzback]

It would be interesting if we could build a list of the shows that are listed the most and sort them. Forget Neilsen ratings, MR FTW.

 

[Mike Garcen]

that’s actually a great idea…i’m not sure how we’d do it. I’ll talk to Mikinho and see if there’s a way, maybe if we can parse spaces…but since everyone entered their shows differently it may be challenging…but definitely we’ll look into it. Great idea!

[PAPutzback]

That spaces part gives me an idea. Can I get a dump of the entire thread in one text file.

I think if you parsed every word into a column and then did something like:

Select word, count (word) as TimesRepeated

WHERE word not in (SELECT word from CommonWords)

FROM Word

group by word

ORDER BY count (word) Asc

 

[mikinho]

When the contest finishes next week I can do that.

[Author]

Posts