Question getting rid of ' ' answers

[russi]

Hi.
I have a database file (Access 97) where many user answers are: ' '

When saving it as a text file, I need to replace these answers with: ,,

I try using the Replace All method in Notepad after the text file is saved, but it either takes forever, or else the computer freezes.

Any ideas?

Thanks.

Russ

 

[KenHigg]

Are you saying they save a zero length string or they put single quotes in? Can you post some a db with a sample table?

 

[maxmangion]

I try using the Replace All method in Notepad

Not sure about the reasoning why some of your users enter the quotes, but have you considered using an update query instead of the search and replace in notepad