Name Manipulation
jerryn3
First I should say I am not familiar with Visual Basic.
I am trying to break up a name field with various name formats into 2
separate fields:
1. firstname and initial, if included
2. lastname, and suffix if included
The various name formats are similar to these:
Mr. & Mrs. John R. Smith, III
Mr. Henry B. Jones & Ms. Hillary Loper
Kay M Conroy Peckham
Thomas F & Joyce Mlyniec
J. Smith, MD
Can anyone help?
Thank you!
--
Posted via http://dbforums.com
PC Datasheet
want to do. I suggest you export what you have into Excel where it
is a little easier to manually work with, manuall break up the
names and then import them back into Access. Hope you don't have
too many names!
--
PC Datasheet
A Resource for Access, Excel and Word Applications
reso...@pcdatasheet.com
www.pcdatasheet.com
· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
"jerryn3" <je...@libertech.net> wrote in message
news:2033741.1...@dbforums.com...
Sith Lord
<2033741.1...@dbforums.com>, jerryn3 <je...@libertech.net>
wrote:
I'd agree with "PC Datasheet" (I wonder which constabulary he works in
<g>) I once tried to create letters from a database with names all in
one field, I had things like if it started "Mr" then take "Mr" and the
last word, if not then take the first word as they were on first name
terms, this presented problems like:
Squadron Leader Bill Smith
Dear Squadron,
Mr William Gates III
Dear Mr III,
You see to counter all these you must build up a vocabulary and how
many salutations do you know? How many "letters after the name" do you
know? e.g. my father had the letters "M.I.T.E" and "F.S.E.R.T" after
his name, we used to joke about "dad might for cert." but have you
ever heard of them? No-one will know them all and to compile and
produce such a dictionary would probably take as much if not more time
as following PC's suggestion and mangle the names manually. In the
case of "Kay M Conroy Peckham", how do you determine between a middle
name and a double barreled surname? Tough enough manually let alone
code it.
--
Dim Salary As Currency
Dim Overtime As Double
jerryn3
The only problem is there are 1,300,000 records and you can't even
get that is excel. I think I can get rid of all the Mr and Mrs at the
begining by using a Find & Replace. I just don't know what to do
about the rest.
Thanks for all the replies!
Jerry
Larry Linson
name-splitting, either, and some of us have been around since computing's
"Dark Ages". The best suggestions I have seen, here or elsewhere, are to
come up with what you think is a more-or-less workable algorithm, try it and
refine it, and then fix the names manually that it didn't get right. Someone
else's algorithm is likely not to be the best for you, because there is so
much variation in lists of names.
--
Larry Linson http://www.ntpcug.org -- North Texas PC User Group
http://members.tripod.com/ntaccess -- Access SIG
http://members.tripod.com/accdevel -- Access Samples and Examples
http://appdevissues.tripod.com/downloads.htm -- Presentations
"jerryn3" <je...@libertech.net> wrote in message
news:2034890.1...@dbforums.com...
Terry Chapman
Larry Linson
good job.
--
Larry Linson http://www.ntpcug.org -- North Texas PC User Group
http://members.tripod.com/ntaccess -- Access SIG
http://members.tripod.com/accdevel -- Access Samples and Examples
http://appdevissues.tripod.com/downloads.htm -- Presentations
"Terry Chapman" <wemba_remo...@bigpond.com> wrote in message
news:vkzA9.76045$g9.2...@newsfeeds.bigpond.com...