Re: Replacing Special Characters in Database

[RJR Computing Solutions, Inc.]

Since the database is in Access, you can export the table to a text file,
manipulate the data using find and replace functions in many editors, and
import the data back in.  The database is live, but I would expect your
product table is static enough to not change while you do the data cleanup.

Studio's Find and Replace is very good, but if you can't locate the bad
characters, you might need something more powerful like Word.

Bob.

----- Original Message -----
From: "Josh R" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 08, 2001 9:23 PM
Subject: Replacing Special Characters in Database


> OK, here's the problem.
>
> We had to import our old databse into MS Access 97 and found that all the
> special characters in a memo field for product descriptions have gone
crazy.
> � and � replaced ",  � replaced -, � replaced ', etc.
>
> So I need to go into the 2000+ fields we have and replace all these
> characters back to their proper settings without destroying the
> descriptions. (I tried using a query and looping over the replace feature,
> but it pasted the first description into all the other 2000 fields. NOT
> GOOD.)
>
> What's the safest way to do this on a live databse?
> Thanks for your help.
>
> Josh Rubak
> [EMAIL PROTECTED]
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists