Finding a special characterlike +

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

Guest

I have a table called "Outlook Contacts". I need to find and replace a few
characters in this table. One of them is the plus sign '+'. I need to do
this in my code, though. I need to search for the sign + in the field called
"Full Name" and replace it with nothing (delete it). Then I need to search
the whole table for the ^ sign and replace it with nothing.
thanks,
ck
 
Charlie,

You can use an Update Query to do this. For example, update your Full
Name field to...
Replace([Full Name],"+","")

With the "^" character, you will need to apply the Update To to every
applicable field in the table.
 
Back
Top