[AccessD] Replace Special Characters

Ack, you mean run a replace on all non-alphanumeric characters?  Wouldn't
that be a bit excessive?

Drew

-----Original Message-----
From: Andy Lacey [mailto:andy at minstersystems.co.uk]
Sent: Thursday, April 10, 2003 2:50 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Replace Special Characters


Terri
Check out the Replace function (not in A97 though)

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Terri Jarus
> Sent: 10 April 2003 20:39
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Replace Special Characters
> 
> 
> I want to be able to go through a column of data and strip
> out any special characters (,./"'-*&!, etc.) and store the 
> "clean" data to a new column.
> 
> "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890"
> 
> How would I go about doing this?
> 
> Thanks for any help.
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com