Results 1 to 5 of 5

Thread: Display Phonebook by Last Name?

  1. #1
    Low Bitrate GRod's Avatar
    Join Date
    Aug 2003
    Location
    San Diego
    Posts
    98

    Display Phonebook by Last Name?

    I've uploaded my phone book successfully, but all the listings are sorted by first name and I'd like to have it listed by last name. I've searched posts here and on your site, but no luck. Any advice?

    GRod
    Carputer/AV System ~95% complete
    Parts all acquired - testing underway
    Fabrication and integration underway
    More on my Ride

  2. #2
    Variable Bitrate
    Join Date
    Sep 2004
    Posts
    326
    I assume you are talking about phonecontrol.net

    Most phones have only one data field for name. Therefore unless you re-enter your phone book with Surname,Firstname .... then no.

  3. #3
    Low Bitrate GRod's Avatar
    Join Date
    Aug 2003
    Location
    San Diego
    Posts
    98
    Crap I'm not looking forward to re-entering all the names - maybe I'll try re-exporting into Excel and work with them there.

    Yes, I am referring to PhoneControl - it's a great program - luv it
    Carputer/AV System ~95% complete
    Parts all acquired - testing underway
    Fabrication and integration underway
    More on my Ride

  4. #4
    Variable Bitrate
    Join Date
    Sep 2004
    Posts
    326
    Unless you are pretty good at SQL, exporting them into Excel won't help. You'll still only have one field.

  5. #5
    Maximum Bitrate Bravellir's Avatar
    Join Date
    Dec 2003
    Location
    Porto, Portugal
    Posts
    741
    Quote Originally Posted by Matthew230
    Unless you are pretty good at SQL, exporting them into Excel won't help. You'll still only have one field.

    Can be done by using this formula in Excel

    =CONCATENATE(RIGHT(A4;LENGHT(A4)-LOCATE(" ";A4;1));", ";LEFT(A4;LOCATE(" ";A4;1)))

    Not sure about the function names, because my excel is localized, but they should be easy enough to correct if wrong.

    If you have "First Last" on A4, the formula will give you "Last, First"
    Ikea Case. Epia M10000.M1-ATX. 512 Mb. 2,5" 80 GB HDD. 7" Lilliput. BU-303 GPS. Sony Joystick.
    Status -->
    Lilliput Installed (not indash yet..)
    BraveCar 2.5

Similar Threads

  1. Matrix Orbital GLK-12232 Display Software
    By dug1967 in forum General Hardware Discussion
    Replies: 4
    Last Post: 08-15-2006, 01:10 PM
  2. Replies: 2
    Last Post: 03-01-2005, 01:59 PM
  3. Stupid Xenarc! It won't turn on when laptop is on or display correct!!
    By PDiddy in forum General Hardware Discussion
    Replies: 18
    Last Post: 01-17-2005, 08:53 PM
  4. Any way to relocate my display card??
    By SlimJimmy in forum General Hardware Discussion
    Replies: 13
    Last Post: 03-22-2004, 10:14 PM
  5. Choosing a Character display...
    By Kryten in forum LCD/Display
    Replies: 3
    Last Post: 10-16-2003, 11:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •