Discussion in '$1 Daily Competition' started by shabbir, Aug 21, 2009.
Any username that has 25 chars as that was the limit quite sometime back
seeing you this late after a long time
I think all did the job manually....
I used Excel, and a little VBA to fetch the records to excel, and then the formula len() to check for the longest username
i used php crawler with mysql db :/
dirty solution, a little...
haha, that's what I wanted to ask earlier, did you do it manually or use something
did anyone else did not do manually?
I did. I Used my brain and didnt bother checking for the answer :p lolzz
ps - how did u use Excel and VBA? btw?
this should explain you how did I did it
1] got the url with name sorted datewise
2] record a macro
3] new web query
4] used the url from step 1
5] selected the table only with the user details
6] this gave me 100 records in 1 step
7] modified the macro to get the info for all the records that could fit on one sheet
8] used len(), and sort desc
9] confirmed back the result from the forum
letting out my secrets :lol:
forgot to reply, I don't get it still, :S what do you mean record a macro? where?
@Mj: Check the attached file.
I used the similar one to find the longest username
Don't you know about macros?
i know about macros but never used them...my laptops gone bad, getting no display, when i get it back i'll check it as these days im using comp at cyber cafes
Separate names with a comma.