MS Access Split file module ????

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

Rather odd bit of code that would be, but the folks that are in the
Access specific group might be willing to help you out.

Hans Stope wrote:

> 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

Hi Hans,

You may want to use the link below to post this in the MS Office Access discussion group and include there the version of Access
you're using.

===========
<<"Hans Stope" <hans-on@news.postalias> wrote in message news:2FED5494-E3B3-4F93-A1CF-ECA9ACC18AA7@microsoft.com...
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>>
--
Please let us know if this has helped,

Bob Buckland ?:-)
MS Office System Products MVP

>>*Courtesy is not expensive and can pay big dividends<<

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
or via browser:
http://microsoft.com/communities/new....public.access

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/communit...s/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com