Striping a ' from a field 1

[meagain]

I have a table from which I export to a txt file for import into another database. The import won't accept ' in any of the fields, and since there are 's in the originating table I need to find a way to remove them prior to the export taking place, (ie: Andy's Place needs to be changed to Andys Place prior to export)

The 's can appear anywhere in 4 different fields.

We are using Access 2000.

Any ideas on how I can strip out the 's in my fields?


Thanks alot,
Lori

 

[PHV]

Export a query instead of the table:[tt]
SELECT Replace([field 1], "'", "") AS Field1
, Replace([field 2], "'", "") AS Field2
...[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[meagain]

PH, thanks so much for the tip, it worked well in removing the apostrophe.

Any advice on stripping quotation marks? As you know because it is a quote in between 2 quotes, Access thinks I've left a string unfinished. Any tricks to get it to register that I want quotation marks replaced?

Thanks a lot

 

[Golom]

SELECT Replace([field 1], """", "") AS Field1

 

[meagain]

Thanks Golom, that did the trick.