0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Any username that has 25 chars as that was the limit quite sometime back
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
seeing you this late after a long time
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
Quote:
Originally Posted by xpi0t0s View Post
Is it possible to find this out by other means than just scrolling endlessly through user lists?
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
0
mayjune's Avatar, Join Date: Jun 2009
Invasive contributor
cool
0
exile's Avatar, Join Date: Jun 2009
Go4Expert Member
i used php crawler with mysql db :/
dirty solution, a little...
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
haha, that's what I wanted to ask earlier, did you do it manually or use something

did anyone else did not do manually?
0
mayjune's Avatar, Join Date: Jun 2009
Invasive contributor
I did. I Used my brain and didnt bother checking for the answer lolzz

ps - how did u use Excel and VBA? btw?
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
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
mayjune, SaswatPadhi likes this
0
mayjune's Avatar, Join Date: Jun 2009
Invasive contributor
@KFP
forgot to reply, I don't get it still, :S what do you mean record a macro? where?
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
@Mj: Check the attached file.
I used the similar one to find the longest username

Don't you know about macros?
Attached Files
File Type: zip Usernames.zip (7.4 KB, 3 views)
SaswatPadhi like this