[AccessD] Replace Special Characters

We all have those sorts of days!  

Drew

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


Yea you're probably right. Didn't give that one enough thought.
Concentrate Andy, concentrate!

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



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
> Sent: 10 April 2003 21:12
> To: 'accessd at databaseadvisors.com'
> Subject: RE: [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/a> ccessd
> Website: 
> http://www.databaseadvisors.com 
> _______________________________________________
> 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