A query to removed any unwanted characters

[KenshiroUK]

A query to remove any unwanted characters

Hi there, I'm wondering if it is possible to create a query with a select query to delete any unwanted characters. For example I created a query to select customer details addresses and names etc, however some of the addresses contain quotation marks and I wish to filter these out. Please not the customer details are in fact stored within a linked table to note, so I can not edit with Access as it is set to 'Read Only' and I do not wish to look for hundreds of records with in a text file to delete these quotations within that.

 

[AccessMSSQL]

You can use the replace function in your query:

Replace([YourField],Chr(34),"")

 

[KenshiroUK]

You can use the replace function in your query:

Replace([YourField],Chr(34),"")

Hi thanks, I have added it into the field, however the customer details with the quotations marks has not appeared.

 

[AccessMSSQL]

Yes, the replace function removes the double-quotes so you aren't going to see them. If you want to actually update the field that has double-quotes and remove them you need to write an update query and then in the Update TO Row put that same function in there.