Re: [U2] Extract first and last name from free-form name

And the list goes on and on and... That's why free form names are an absolute pain and should be avoided. It's so much easier to have Title, First Name(s), Last Name(s) fields in the input screen and keep them as separate attributes. You never get it 100% right. In your list take Dean or Prince

Re: [U2] Extract first and last name from free-form name

This thread reminded me of a blog posting I ran across a while ago. His basic premise is that most of our assumptions about names are incorrect, which makes coding a computer to handle them properly is really tough if not impossible. Don't skip the comments section, there's some good stuff

Re: [U2] Extract first and last name from free-form name

Subject: Re: [U2] Extract first and last name from free-form name This thread reminded me of a blog posting I ran across a while ago. His basic premise is that most of our assumptions about names are incorrect, which makes coding a computer to handle them properly is really tough

Re: [U2] Extract first and last name from free-form name

From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah [cwn...@comcast.net] Sent: Tuesday, December 13, 2011 8:02 PM To: U2 Users List Subject: Re: [U2] Extract first and last name from free-form name Great

Re: [U2] Extract first and last name from free-form name

-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen [ggal...@wyanokegroup.com] Sent: Wednesday, December 14, 2011 4:19 AM To: U2 Users List Subject: Re: [U2] Extract first and last name from free-form name If it's a single letter, it's considered a middle initial, ONLY if there has been

Re: [U2] Extract first and last name from free-form name

December 2011 08:22 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Extract first and last name from free-form name And the list goes on and on and... That's why free form names are an absolute pain and should be avoided. It's so much easier to have Title, First Name(s), Last Name(s) fields

Re: [U2] Extract first and last name from free-form name

-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 14 December 2011 08:22 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Extract first and last name from free-form name And the list goes on and on and... That's why free form names

Re: [U2] Extract first and last name from free-form name

-Original Message- From: Mecki Foerthmann mec...@gmx.net To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Dec 14, 2011 5:09 am Subject: Re: [U2] Extract first and last name from free-form name Just face it - it can't be done! So what if Dean has 2 first names and is a plumber? On 14/12/2011 09

Re: [U2] Extract first and last name from free-form name

Hi Mecki, I absolutely agree. Of course, it's hard enough to get a trained (hopefully) data entry person to get it right, just imagine all those web customers filling out online order forms. The best you can hope for is to get most right, and enough time to look over the rest for errors.

Re: [U2] Extract first and last name from free-form name

: [U2] Extract first and last name from free-form name Just face it - it can't be done! So what if Dean has 2 first names and is a plumber? On 14/12/2011 09:57, Symeon Breen wrote: You need to do a proper lexical analysis in order to work these out For example Input : Dean Foster Lex: title

Re: [U2] Extract first and last name from free-form name

I'm late to the Party, but wrote this draft yesterday. Some of it has been covered, but I'll click send without further revisions. I did not see the original post on this (just the Re:) but you can only get somewhat close on extracting first or last names from a free-form name, not good enough to

Re: [U2] Extract first and last name from free-form name

Count Darling IV is alive and well. He lives in Fayetteville, AR still works with mvBase. George -Original Message- From: Charlie Noah Sent: Wednesday, December 14, 2011 8:00 AM To: U2 Users List Subject: Re: [U2] Extract first and last name from free-form name And how about Count

Re: [U2] Extract first and last name from free-form name

- *From:* syme...@gmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 12/14/2011 1:57 AM *Subject:* Re: [U2] Extract first and last name from free-form name You need to do a proper lexical analysis in order to work these out For example Input : Dean Foster Lex: title word

Re: [U2] Extract first and last name from free-form name

In today's modern world we have a luxury which is not being utilized. Depending on your audience, most people these days have access to cell phones, e-mail, web pages (even Facebook), etc. Rather than trying to get algorithms or employees to guess at which field is which, just let human beings

Re: [U2] Extract first and last name from free-form name

their shift key. -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Dec 14, 2011 10:02 am Subject: Re: [U2] Extract first and last name from free-form name In today's modern world we have a luxury which is not being tilized

Re: [U2] Extract first and last name from free-form name

Or you could use pre-packaged software to do it for you. I've used ParseRat http://www.guysoftware.com/parserat.htm for parsing report output and it worked really well - although the interface is getting extremely dated. Haven't tried it for names - but it would be way easier than reinventing the

Re: [U2] Extract first and last name from free-form name

...@sneakemail.com] Sent: Wednesday, December 14, 2011 1:02 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Extract first and last name from free-form name In today's modern world we have a luxury which is not being utilized. Depending on your audience, most people these days have access to cell phones

Re: [U2] Extract first and last name from free-form name

On 14/12/11 16:30, Bill Haskett wrote: As usual, one has to ask if the complexities involved in managing all potentialities ensures that the simplest, and by far the most usual, scenarios are at best difficult to implement. :-( Bill The trouble is, even in the Anglo-Saxon world, what YOU think

Re: [U2] Extract first and last name from free-form name

*Date:* 12/14/2011 2:32 PM *Subject:* Re: [U2] Extract first and last name from free-form name On 14/12/11 16:30, Bill Haskett wrote: As usual, one has to ask if the complexities involved in managing all potentialities ensures that the simplest, and by far the most usual, scenarios are at best

Re: [U2] Extract first and last name from free-form name

0044: SUFFIXES = ,JR,SR,MD,III, 0045: S.NAME = DCOUNT(UM.NAME,' ') 0046: LAST.WORD.IN.NAME = FIELD(UM.NAME,' ',S.NAME) 0047: IF INDEX(SUFFIXES,,:LAST.WORD.IN.NAME:,,1) THEN 0048: LAST.NAME = FIELD(UM.NAME,' ',S.NAME-1) 0049: END ELSE 0050:

Re: [U2] Extract first and last name from free-form name

Great start, but here is a longer list, although still nowhere near complete: Prefixes Code Description 1st Lt First Lieutenant Adm Admiral Atty Attorney Brother Brother (religious) Capt Captain ChiefChief Cmdr Commander Col Colonel Dean University Dean

Re: [U2] Extract first and last name from free-form name

This reminds me that around 1990 I wrote functions like this in F correlatives that wrapped around the screen several times, one dict item for each name part. Oh joy. From: Charlie Noah Great start, but here is a longer list, although still nowhere near complete: [snip] Wjhonson wrote: