1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Longest Username | 21 Aug 2009

Discussion in '$1 Daily Competition' started by shabbir, Aug 21, 2009.

  1. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    Any username that has 25 chars as that was the limit quite sometime back
     
  2. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    seeing you this late after a long time :)
     
  3. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    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 :)
     
  4. mayjune

    mayjune New Member

    Joined:
    Jun 14, 2009
    Messages:
    817
    Likes Received:
    33
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Pune,Delhi
  5. exile

    exile New Member

    Joined:
    Jun 8, 2009
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    0
    i used php crawler with mysql db :/
    dirty solution, a little...
     
  6. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    haha, that's what I wanted to ask earlier, did you do it manually or use something :)

    did anyone else did not do manually?
     
  7. mayjune

    mayjune New Member

    Joined:
    Jun 14, 2009
    Messages:
    817
    Likes Received:
    33
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Pune,Delhi
    I did. I Used my brain and didnt bother checking for the answer :p lolzz

    ps - how did u use Excel and VBA? btw?
     
  8. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    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:
     
  9. mayjune

    mayjune New Member

    Joined:
    Jun 14, 2009
    Messages:
    817
    Likes Received:
    33
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Pune,Delhi
    @KFP
    forgot to reply, I don't get it still, :S what do you mean record a macro? where?
     
  10. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    @Mj: Check the attached file.
    I used the similar one to find the longest username

    Don't you know about macros?
     

    Attached Files:

  11. SaswatPadhi

    SaswatPadhi ~ Б0ЯИ Τ0 С0δЭ ~

    Joined:
    May 5, 2009
    Messages:
    1,343
    Likes Received:
    55
    Trophy Points:
    0
    Occupation:
    STUDENT !
    Location:
    Orissa, INDIA
    Home Page:
    Thanx nimesh :)
     
  12. mayjune

    mayjune New Member

    Joined:
    Jun 14, 2009
    Messages:
    817
    Likes Received:
    33
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Pune,Delhi
    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 :(
     

Share This Page