1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,293
    Likes Received:
    365
    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:
  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