MS Access Split file module ????

[Hans Stope]

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

 

[Bob I]

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.

 

[Bob Buckland ?:-\)]

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.

===========
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

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.access

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