Break Fullname Into First And Last Name

[AndyInUK]

Hi , How can i break Fullname Into First And Last Name. For instance there is a column with name "Mr James Smith" and i want to break this into 3 columns with Title, FirstName and LastName. Thank You

[Andy_L_J]

http://www.devx.com/tips/Tip/20009[^]

I don't speak Idiot - please talk slowly and clearly 'This space for rent' Driven to the arms of Heineken by the wife

[Lost User]

Be carefull with those; some people have no title, but a compound First-name, or a surname that's made up out of multiple names. I'd check the first argument from the string against a known list of titles, just to see whether that part was included or whether it's a first name.

I are Troll :)

[dan sh]

Given the various kinds of name people have in various parts of world, you can not be sure that your code will work fine. It will irritate one person with different kind of name. Still, you can have something predefined like: 1. First two words will go in as first name. 2. Last word will be the Last name. 3. Rest can be treated as middle name. Beware, Sean Claude Van Dam will be angry by this approach.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

[J4amieC]

d@nish wrote:

Sean Claude Van Dam

Jean

[Lost User]

J4amieC wrote:

Jean

I think Sean is the Irish one :laugh:

[dan sh]

I wasn't sure about the spelling. Hence I checked in google and got the results. Although I did not bothered to look down the page.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD