• Jeff Moden (7/6/2009)


    Sergiy (7/5/2009)


    Jeff Moden (7/2/2009) Andrew already did exactly what I would do...

    I would not.

    There was a member of Led Zeppelin, John Paul Jones.

    Would not be happy seeing his name after such "parsing".

    Sergiy is actually the most correct on this. Full name parsing is dangerous at best especially considering that you can have 3 part last names like Van de Graff or the like. The proper way to do this is to head the data provider in the head with a bat and get them to provide the data in the correct format of last name being it's own column.

    I've built a splitter for this type of thing including many of the 3 part names, but no lookup list in the world is going to be able to resolve all the names in the world. The data must be entered correctly in some GUI somewhere.

    It works only for a specific style (format) of name. That's the problem with trying to split "free text" columns, especially names.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)