[AccessD] A2003: Replace the Hash Character

In your query, let's say the field's name is 'DataField'.  Create an update
table, and put the following as the UpdateTo portion:

Replace([DataField],"#","")

That will remove all the number sign characters.

Drew

-----Original Message-----
From: Darren DICK [mailto:darrend at nimble.com.au] 
Sent: Tuesday, September 12, 2006 6:11 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2003: Replace the Hash Character

Hi All
 
I am trying to replace the # character in a table
 
I have about 3 hundred records and one of the fields in that 300 or so
records
has data in it similar to #123-ABC
 
I want to Find and Replace the # with nothing so the data in the fields
looks
like 123-ABC
 
When I do open the table and Use find and replace and use # as the
searchable
item it actually finds all the numbers EG 3 4 6 etc in each record
 
Not the actual character
 
I have tried '#' and "#" in my search field - no joy
 
Anyone know how to do a find and replace on the actual character # not on
numbers?
 
MTIA
 
Darren
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com