Code to Split field content

[shawnews]

I need to split the name field content of an imported table in a MS Access
database. For instance: Mr. H.C.J van der Laan-ter Broek.

It needs to be split in:
Honorific: Mr.
Initials: H.C.J.
Prefix1: van der
LastName1: Laan
Prefix2: ter
LastName2: Broek

Does anyone have a piece of code that would accomplish this?

Thanks

 

[John W. Vinson]

I need to split the name field content of an imported table in a MS Access
database. For instance: Mr. H.C.J van der Laan-ter Broek.

It needs to be split in:
Honorific: Mr.
Initials: H.C.J.
Prefix1: van der
LastName1: Laan
Prefix2: ter
LastName2: Broek

Does anyone have a piece of code that would accomplish this?

This may not be possible even in principle. What is the appropriate FirstName
and LastName for:

Jerry Joe Smith
Jerry Lynn Smith
Huang Lee Wong
Huang Lee Wong
Madonna

(It's FN Jerry Joe, LN Smith; FN Jerry, LN Lynn Smith or Lynn-Smith; FN Lee
Wong, LN Huang; FN Huang Lee LN Wong; and durned if I know, respectively).

If you're working exclusively with Dutch names it might be a *little* bit
easier... but I don't think you can expect any 100% perfect automated
solution!


John W. Vinson [MVP]

 

[Marshall Barton]

I need to split the name field content of an imported table in a MS Access
database. For instance: Mr. H.C.J van der Laan-ter Broek.

It needs to be split in:
Honorific: Mr.
Initials: H.C.J.
Prefix1: van der
LastName1: Laan
Prefix2: ter
LastName2: Broek

Does anyone have a piece of code that would accomplish this?

Good luck. You can program a specific set of rules, but
there is no such thing as a generis set of rules for all
names. People's names are spelled and punctuated in
whatever way they or their parents want it to be.


The best I have seen is about 60% accuracy across a few
nationalities/cultures and even then it too a large amount
of work before it could even do that well.

 

[Hans]

Thanks for your input John. Yes, they will ne mostly Dutch names.

I have some code that'll do most of it, but I get stuck on the last name
portion. The minimum I need is the Honorific, Initials, Prefix and LastName,
like: Laan-ter Broek.

That would make it look like:
Honorific: Mr.
Initials: H.C.J.
Prefix: van der
LastName: Laan-ter Broek

Any suggestions?

 

[John W. Vinson]

Thanks for your input John. Yes, they will ne mostly Dutch names.

I have some code that'll do most of it, but I get stuck on the last name
portion. The minimum I need is the Honorific, Initials, Prefix and LastName,
like: Laan-ter Broek.

That would make it look like:
Honorific: Mr.
Initials: H.C.J.
Prefix: van der
LastName: Laan-ter Broek

Any suggestions?

Not being familiar with Dutch name conventions, nor with how regular or
irregular your data might be, I'm afraid not. I wonder if you might get some
more knowledgable help posting in microsoft.public.nl.access?

John W. Vinson [MVP]