Code to Split field content

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shawnews - 27 Mar 2007 22:33 GMT

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

Reply to this Message

John W. Vinson - 27 Mar 2007 23:37 GMT

>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.
[quoted text clipped - 8 lines]
>
>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]

Reply to this Message

Hans - 28 Mar 2007 02:16 GMT

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?

>>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.
[quoted text clipped - 28 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 28 Mar 2007 06:13 GMT

>Thanks for your input John. Yes, they will ne mostly Dutch names.
>
[quoted text clipped - 9 lines]
>
>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]

Reply to this Message

Marshall Barton - 27 Mar 2007 23:49 GMT

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.

Signature

Marsh
MVP [MS Access]

Reply to this Message