Finding a special characterlike +

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charlie - 29 Apr 2006 23:01 GMT

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

Reply to this Message

Steve Schapel - 29 Apr 2006 23:13 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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
[quoted text clipped - 3 lines]
> thanks,
> ck

Reply to this Message