How to search an Access table for unwanted <cr> characters

[adrian.stock22]

How to search an Access table for unwanted <cr> characters

Occasionally a stray carriage return <cr> Ascii 013 character finds its way into an Access table. These destroy the database when the table is processed by an outside utility for data cleansing.

To prevent this from happening, we have been told to clean the table before submitting it, i.e. remove all of the following:

carriage return, comma, double quotes, equals, greater than, smaller than

Is there any utility available which will remove all these characters when being run only once? (i.e. not find/replace which has to be started separately for each of these characters)

How do I search for a <cr>, even with find/replace?

Thanks.

Adrian

 

[ghudson]

Use the Replace() functon to find and replace the unwanted characters. No matter what method you use; you will still have to "call" it when needed.

 

[adrian.stock22]

Hi gHudson,

Thanks for that. Haven't used any functions before but have book and will now find out how it works.

tx

Adrian