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,375
    Likes Received:
    388
    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:
    769
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    http://techiethakkar.blogspot.com
    seeing you this late after a long time :)
     
  3. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    769
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    http://techiethakkar.blogspot.com
    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:
    814
    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:
    769
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    http://techiethakkar.blogspot.com
    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:
    814
    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:
    769
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    http://techiethakkar.blogspot.com
    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:
    814
    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:
    769
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    http://techiethakkar.blogspot.com
    @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,342
    Likes Received:
    55
    Trophy Points:
    0
    Occupation:
    STUDENT !
    Location:
    Orissa, INDIA
    Home Page:
    http://www.crackingforfun.blogspot.com
  12. mayjune

    mayjune New Member

    Joined:
    Jun 14, 2009
    Messages:
    814
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice