Name Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Name field that I'm getting from a Txt file. It comes in the
following format
"ARCHER, ADAM JOHN" At this time I Do a Find a Replace so that the Name
will not have the " or the ,. so the name looks like ARCHER ADAM JOHN . Can I
do this in the Query?

Thanks for your help!!!
 
I have a Name field that I'm getting from a Txt file. It comes in the
following format
"ARCHER, ADAM JOHN" At this time I Do a Find a Replace so that the Name
will not have the " or the ,. so the name looks like ARCHER ADAM JOHN . Can I
do this in the Query?

Thanks for your help!!!
Click to expand...

I'm going to answer below but... I really feel queasy about your
intended goal. Most would want to keep LastName and FirstName fields
separate. What about names such as

"VAN DER STEEN, HANS"
"VON TRAPP, MARIA"
"VAN ADAM, JOHN"

Your proposal will make it impossible to correctly parse first and
last names in many of these cases.

In addition, NAME is a reserved word in Access. A Form has a Name
property; a textbox has a Name property; even a query has a Name
property. Access *WILL* get confused. Consider using a different Name
for Name!

That said... update the field using an Update query (not a Find and
Replace); update it to

Replace(Replace([NAME], """", ""), ",", "")

The four quotes in a row is how you need to depict a single quote
mark.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top