Darren DICK
darrend at nimble.com.au
Tue Sep 12 19:01:07 CDT 2006
Excellent Worked like a charm Many thanks Darren ------------------ T: 0424 696 433 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Wednesday, 13 September 2006 9:16 AM To: accessd at databaseadvisors.com Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com